//js前台代码
<head id="Head1" runat="server">
<title>google</title>
<link href="css/jquery.autocomplete.css" rel="stylesheet" type="text/css" />
<script src="js/jquery.js" type="text/javascript"></script>
<script type='text/javascript' src="js/jquery.autocomplete.js"></script>
<script type="text/javascript">
function findValue(li){
if( li == null ) return alert("No match!");
if( !!li.extra )
var sValue = li.extra[0];
}
function selectItem(li){
findValue(li);
}
function lookupLocal(){
var oSuggest = $(".ajaxinput")[0].autocompleter;
oSuggest.findValue();
return false;
}
$(document).ready(function(){
$("#ac_me").autocomplete("AutoCompleteData.aspx",{
delay:10,
minChars:1,
matchSubset:1,
cacheLength:1,
onItemSelect:selectItem,
onFindValue:findValue,
autoFill:true,
maxItemsToShow:20
});
});
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<input id="ac_me" type="text" />
</div>
</form>
</body>
后台代码:
string key = Request.QueryString["q"];
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
SqlConnection connection = new SqlConnection(connectionString);
string sql = "select Cname from test2 where Cname like'%"+key+"%'";
SqlCommand command = connection.CreateCommand();
command.CommandText = sql;
connection.Open();
StringBuilder items = new StringBuilder();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
items.Append(reader.GetString(0) + "\n");
}
}
Response.Write(items.ToString());
Response.End();