“select *从数据库当中获取的字段* from *表名* InStr(1,LCase(*要搜索的字段*),LCase('*文本框中的内容*'),0)<>0”此方法意指是从当前要搜索的字段当中检索文本框的值..
如果符合,则被获取出来,之后循环显示。
如果符合,则被获取出来,之后循环显示。
解决方案 »
- 单个表如何缓存?
- WPF DataGrid 打印查询出来的数据 怎么实现呢· 在线等待ING
- 如何三个表连接起来查询?
- .net 2.0 怎么替换关键字?
- 请教:实现DataTable.Select()的这样筛选行的条件:
- 兄弟门,刚离职,我又重新找工作,面试过了,但郁闷的事情又来。进来帮我建议一下,在线等急得很呐。
- 写一个简单的查询
- Windows Service用try捕获exception怎么不行?
- .net中的ECB加密算法疑问??
- 关于datagrid和dropdownlist的问题,请大家帮帮忙,谢了
- 我的Entity framework DBContext没有Attach?
- 请问下面这个类型如何转换呢?
看看是不是你想要的
http://www.cnblogs.com/insus/archive/2011/07/16/2108172.htmlhttp://www.cnblogs.com/insus/archive/2013/03/28/2986217.htmlhttp://www.cnblogs.com/insus/archive/2013/04/05/2986989.html
里面有源码啊,有demo<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>jQuery UI Autocomplete - Default functionality</title>
<link rel="stylesheet" href="http://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css" />
<script src="http://code.jquery.com/jquery-1.9.1.js"></script>
<script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></script>
<link rel="stylesheet" href="/resources/demos/style.css" />
<script>
$(function() {
var availableTags = [
"ActionScript",
"AppleScript",
"Asp",
"BASIC",
"C",
"C++",
"Clojure",
"COBOL",
"ColdFusion",
"Erlang",
"Fortran",
"Groovy",
"Haskell",
"Java",
"JavaScript",
"Lisp",
"Perl",
"PHP",
"Python",
"Ruby",
"Scala",
"Scheme"
];
$( "#tags" ).autocomplete({
source: availableTags
});
});
</script>
</head>
<body>
<div class="ui-widget">
<label for="tags">Tags: </label>
<input id="tags" />
</div>
</body>
</html>
但是如果不是很大数据量,e.g.只有几十条的时候 最好一次性拿出来,然后通过js在前台匹配,
针对这两种情况都有很成熟的jquery 插件。
里面有源码啊,有demo<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>jQuery UI Autocomplete - Default functionality</title>
<link rel="stylesheet" href="http://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css" />
<script src="http://code.jquery.com/jquery-1.9.1.js"></script>
<script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></script>
<link rel="stylesheet" href="/resources/demos/style.css" />
<script>
$(function() {
var availableTags = [
"ActionScript",
"AppleScript",
"Asp",
"BASIC",
"C",
"C++",
"Clojure",
"COBOL",
"ColdFusion",
"Erlang",
"Fortran",
"Groovy",
"Haskell",
"Java",
"JavaScript",
"Lisp",
"Perl",
"PHP",
"Python",
"Ruby",
"Scala",
"Scheme"
];
$( "#tags" ).autocomplete({
source: availableTags
});
});
</script>
</head>
<body>
<div class="ui-widget">
<label for="tags">Tags: </label>
<input id="tags" />
</div>
</body>
</html>
Jquery 我不是很熟悉 如果我想要查询数据库的数据怎么办?动态的?
前台:
<script type="text/javascript">
$(document).ready(function(){
$("#TextBox1").blur(function(){
var BiaoTi=$("#TextBox1").val();
$.ajax({
url:"DealEdit.aspx?Ran=" +new Date(),
type:"get",
data:"BiaoTi="+escape(BiaoTi),
dataType:"text",
contentType: "application/text",
beforeSend:function(){
$("#span1").html('请等待.........'); },
success:function(msg){
if(msg==1)
{
$("#span1").html("标题不能为空!!!");
$("#Button1").attr({"disabled":"disabled"});
}
else if(msg==2)
{
$("#span1").html("此标题已存在,请更正后重试!!!");
$("#Button1").attr({"disabled":"disabled"});
}
else
{
$("#span1").html("此标题可用!!!");
$("#Button1").removeAttr("disabled");
}
},
error:function(e){
alert(e.responseText);
}
})
});
$("#TextBox1").keyup(function(){
var BiaoTi=$("#TextBox1").val();
$.ajax({
url:"DealEdit.aspx?Ran=" +new Date(),
type:"get",
data:"BiaoTi="+escape(BiaoTi),
dataType:"text",
contentType: "application/text",
beforeSend:function(){
$("#span1").html('请等待.........'); },
success:function(msg){
if(msg==1)
{
$("#span1").html("标题不能为空!!!");
$("#Button1").attr({"disabled":"disabled"});
}
else if(msg==2)
{
$("#span1").html("此标题已存在,请更正后重试!!!");
$("#Button1").attr({"disabled":"disabled"});
}
else
{
$("#span1").html("此标题可用!!!");
$("#Button1").removeAttr("disabled");
}
},
error:function(e){
alert(e.responseText);
}
})
});
})
</script>
后台:
protected void Page_Load(object sender, EventArgs e)
{
if(Request["BiaoTi"]!=null)
{
string BiaoTi =Server.UrlDecode(Request["BiaoTi"].ToString().Trim());
this.str(BiaoTi);
}
}
private void str(string BiaoTi)
{
//string message = string.Empty;
int count =0;
if (BiaoTi=="")
{
//message = "标题不能为空!!!";
count = 1;
}
else if (Display(BiaoTi))
{
//message = "此标题已存在,请更正后重试!!!";
count = 2;
}
else
{
//message = "此标题可用!!!";
count = 3;
}
//Response.Write(message.ToUpper());
Response.Write(count);
Response.End();
}
private bool Display(string BiaoTi)
{
bool result = false;
string strconn = System.Configuration.ConfigurationManager.AppSettings["ConnString"];
SqlConnection connection = new SqlConnection(strconn);
connection.Open();
string sql = string.Format("select * from content where BiaoTi='{0}'", BiaoTi);
SqlCommand cmd = new SqlCommand(sql, connection);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
result = true;
}
else
{
result = false;
}
connection.Close();
return result;
}
你这不需要 引用什么dll 吗?
你这不需要 引用什么dll 吗?
不需要啊,这就是个很简单的jQuery Ajax的例子啊