CS代码
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class AutoComplete : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string bookname = Request.QueryString["param"].ToString();
if (!string.IsNullOrEmpty(bookname))
{
SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=pxh2003;database=TEST");
conn.Open();
string param = bookname + '%';
string sql = "select * from bookT where bookname like '" + param + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
string result = null;
while (dr.Read())
{
result = result + dr["bookname"].ToString();
result = result + "$$";
}