应用Jquery在asp.net中实现输入提示，数据来自数据库

来源：互联网发布：eve人物捏脸数据编辑：程序博客网时间：2024/05/20 09:43

在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"></mce:script>

<body>中加入一个input

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(); }