
asp.net AjaX搜索提示我方的控件有scriptmanager updatePanel控件里有AutoCompleteExtender 就是不好使根
不提示,帮我看看啊!急啊!谢谢啦这是前台的<cc1:AutoCompleteExtenderID="AutoCompleteExtender1"runat="server...
不提示,帮我看看啊!急啊!谢谢啦
这是前台的
<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="TextBox1" MinimumPrefixLength="1" CompletionSetCount="10" ServicePath="WebService.asmx" ServiceMethod="GetHotKey" CompletionInterval="2000">
</cc1:AutoCompleteExtender>
这是WebService.cs里的
[System.Web.Script.Services.ScriptService()]
[WebMethod]
public string[] GetHotKey(string prefixText,int count)
{
string key=prefixText+"%";
string sqlstr = "select top " + count + " HouseTypeName from Houses where HouseTypeName like '" + key + "'";
//SqlConnection sqlcon = new SqlConnection("server=.;database=HouseDB;uid=sa;pwd=sasa");
SqlConnection sqlcon = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["db"].ToString());
SqlDataAdapter sda = new SqlDataAdapter(sqlstr, sqlcon);
DataSet ds = new DataSet();
sda.Fill(ds);
List<string> list=new List<string>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(dr["HouseTypeName"].ToString());
}
return list.ToArray();
} 展开
这是前台的
<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="TextBox1" MinimumPrefixLength="1" CompletionSetCount="10" ServicePath="WebService.asmx" ServiceMethod="GetHotKey" CompletionInterval="2000">
</cc1:AutoCompleteExtender>
这是WebService.cs里的
[System.Web.Script.Services.ScriptService()]
[WebMethod]
public string[] GetHotKey(string prefixText,int count)
{
string key=prefixText+"%";
string sqlstr = "select top " + count + " HouseTypeName from Houses where HouseTypeName like '" + key + "'";
//SqlConnection sqlcon = new SqlConnection("server=.;database=HouseDB;uid=sa;pwd=sasa");
SqlConnection sqlcon = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["db"].ToString());
SqlDataAdapter sda = new SqlDataAdapter(sqlstr, sqlcon);
DataSet ds = new DataSet();
sda.Fill(ds);
List<string> list=new List<string>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(dr["HouseTypeName"].ToString());
}
return list.ToArray();
} 展开
1个回答
展开全部
我写的例子,看看吧
参考资料: http://hi.baidu.com/aplesen/blog/item/96b5fb20573ae0a94723e840.html
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询