Ajax智能提示控件没反应帮忙看看~~
打酱油 2010-12-08 11:31:50 页面代码:
<body>
<form id="form1" runat="server">
<div>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server"
TargetControlID="TextBox1"
ScriptPath="~/WebService.asmx"
ServiceMethod="GetUserPhone"
MinimumPrefixLength="1"
CompletionSetCount="10">
</asp:AutoCompleteExtender>
</div>
</form>
</body>
WebService:
[WebMethod]
public string[] GetUserPhone(string prefixText, int count)
{
List<string> item = new List<string>(count);
SqlConnection conn = new SqlConnection("Data Source=TSDN0015;Initial Catalog=UserDB;Integrated Security=True");
conn.Open();
SqlCommand myCmd = new SqlCommand("select top " + count + " UserPhone from UserInfo where UserPhone like '" + prefixText + "%'group by UserPhone order by UserPhone ", conn);
SqlDataReader da = myCmd.ExecuteReader();
while (da.Read())
{
item.Add(da["UserPhone"].ToString());
}
conn.Close();
return item.ToArray();
}
WebService方法是从数据库查询电话号码,在页面输入开头的数字但是没有提示
各位大侠帮忙看看,谢谢!!!