asp.net 仿百度搜索 智能感知快速搜索

点此链接可直接下载原项目

前台代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace WebApplication1
{
public partial class WebForm2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
[System.Web.Services.WebMethodAttribute(),
System.Web.Script.Services.ScriptMethodAttribute()]
public static string[] GetCompletionList(string prefixText,int count, string contextKey) //count参数默认是10
{
SqlConnection conn;
SqlCommand cmd;
string cmdString =
"Select TITLE from ArticleInfo WHERE PUBLISHER TITLE '" +
prefixText + "%'";
conn = new
SqlConnection(@"data source=.\sqlexpress;database=YYSYD.MDF;integrated security=true");
// Put this string on one line in your code
cmd = new SqlCommand(cmdString, conn);
conn.Open();

SqlDataReader myReader;
List<string> returnData = new List<string>();

myReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

while (myReader.Read())
{
returnData.Add(myReader["TITLE"].ToString());
}
return returnData.ToArray();
}
}
}

后台代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace WebApplication1
{
public partial class WebForm2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
[System.Web.Services.WebMethodAttribute(),
System.Web.Script.Services.ScriptMethodAttribute()]
public static string[] GetCompletionList(string prefixText,int count, string contextKey) //count参数默认是10
{
SqlConnection conn;
SqlCommand cmd;
string cmdString =
"Select TITLE from ArticleInfo WHERE PUBLISHER TITLE '" +
prefixText + "%'";
conn = new
SqlConnection(@"data source=.\sqlexpress;database=YYSYD.MDF;integrated security=true");
// Put this string on one line in your code
cmd = new SqlCommand(cmdString, conn);
conn.Open();

SqlDataReader myReader;
List<string> returnData = new List<string>();

myReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

while (myReader.Read())
{
returnData.Add(myReader["TITLE"].ToString());
}
return returnData.ToArray();
}
}
}