asp.net ajax 自动完成 AutoCompleteExtender 控件,遇到的问题!!
建了Default.aspx和KeyFind.asmx;
KeyFind.cs代码
[System.Web.Script.Services.ScriptService]
public class KeyFind : System.Web.Services.WebService
{
public KeyFind()
{
}
[WebMethod]
public string[] getWordList(string prefixText, int count)
{
string sqlstr = " Data Source=DANNY;Initial Catalog=DG VTV;User ID=SA;Password=233215";
SqlConnection sqlconn = new SqlConnection(sqlstr);
string mysql = "select ProductStandard from Product where ProductStandard like'%"+ prefixText+"%'";;
SqlDataAdapter da = new SqlDataAdapter(mysql, sqlconn);
DataSet ds = new DataSet();
da.Fill(ds, "Product");
string[] returnvalue = new string[ds.Tables["Product"].Rows.Count];
for (int i = 1; i <= ds.Tables["Product"].Rows.Count; i++)
{
returnvalue[i - 1] = ds.Tables["Product"].Rows[i - 1][0].ToString();
}
return returnvalue;
}
}
Default.aspx
<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="TEXT" ScriptPath="KeyFind.asmx" MinimumPrefixLength="2" ServiceMethod="getWordList" CompletionSetCount="10" UseContextKey="True" CompletionInterval="2000">
</cc1:AutoCompleteExtender>
运行后没有任何反映,我测试我的数据查询语句,用gridview测试正常。运行KeyFind.cs在getWordList输入prefixText,count
有结果显示处理,但是运行Default.aspx输入没反映,帮忙看看!!