在index.aspx<head></head>中加入如下代码,这3个文件可以在网上直接收索名字下载
- <mce:script type="text/javascript" src="jquery-1.2.6.pack.js" mce_src="jquery-1.2.6.pack.js"></mce:script>
- <mce:script type="text/javascript" src="jquery.autocomplete.js" mce_src="jquery.autocomplete.js"></mce:script>
- <link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" mce_href="jquery.autocomplete.css" />
- <mce:script type="text/javascript"><!--
- $(document).ready(function() {
- $("#DrugNames").autocomplete("./Search/autocompletetagdata.aspx",
- {
- delay:5,
- minChars:1,
- matchSubset:1,
- matchContains:1,
- cacheLength:10,
- //onItemSelect:selectItem,
- //onFindValue:findValue,
- //formatItem:formatItem,
- autoFill:true
- }
- );
- });
- // --></mce:script>
<body>中加入一个input
- <input type="text" id="DrugNames" name="DrugNames" style="width: 200px;" />
autocompletetagdata.aspx代码如下,前台代码只保留头部
- <@ Page Language="C#" AutoEventWireup="true" CodeFile="autocompletetagdata.aspx.cs" Inherits="Search_autocompletetagdata" %>
后台.cs文件在Page_Init()事件添加代码,test表有CId,Cname字段:
- protected void Page_Init(object sender, EventArgs e)
- {
- if (Request.QueryString["q"] != null)
- {
- string sQry = "Select [CId], [CName] from test where " + "[CName] like '" + Request.QueryString["q"] + "%'";
- SqlConnection conn = new SqlConnection();
- conn.ConnectionString = "Data Source=TMHRI-1RMAQM9LC//SQLEXPRESS;Initial Catalog=SPD;User ID=SpdUser;Password=123456";
- conn.Open();
- SqlCommand sc = new SqlCommand(sQry,conn);
- SqlDataReader oRdr = sc.ExecuteReader();
- while (oRdr.Read())
- {
- Response.Write(oRdr["CName"].ToString() + "|" + oRdr["CId"].ToString() + Environment.NewLine);
- }
- oRdr.Dispose();
- sc.Dispose();
- conn.Dispose();
- }
- Response.End();
- }