自动完成扩展程序不列出记录 [英] autocomplete extender doesnt list the records
本文介绍了自动完成扩展程序不列出记录的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
嗨
我有自动完成的扩展程序来列出名称.但是它不会列出值.
我不知道出什么问题了.
谁能帮我解决这个问题?
这是我的网络方法代码..
[WebMethod]
public string[] getname(string prefixText)
{
DataSet dtst = new DataSet();
SqlConnection sqlCon = new SqlConnection(ConfigurationManager.AppSettings["con"]);
string strSql = "SELECT UserName FROM user_det WHERE UserName LIKE ''" + prefixText + "%'' ";
SqlCommand sqlComd = new SqlCommand(strSql, sqlCon);
sqlCon.Open();
SqlDataAdapter sqlAdpt = new SqlDataAdapter();
sqlAdpt.SelectCommand = sqlComd;
sqlAdpt.Fill(dtst);
string[] cntName = new string[dtst.Tables[0].Rows.Count];
int i = 0;
try
{
foreach (DataRow rdr in dtst.Tables[0].Rows)
{
cntName.SetValue(rdr["UserName"].ToString(), i);
i++;
}
}
catch { }
finally
{
sqlCon.Close();
}
return cntName;
}
这是我的html代码
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="txtname" runat="server" OnTextChanged="txtname_TextChanged" AutoPostBack="True"> <asp:ScriptManager ID="ScriptManager1"
runat="server">
<ajax:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="txtname" ServicePath="WebService.asmx" ServiceMethod="getname" MinimumPrefixLength="1" EnableCaching="true">
</div>
</form>
</body>
</html>
解决方案
我认为您的值从零开始，如果是，则将其设为任何字符一个，否则将给您带来麻烦从数据库中获取值
请参阅此
使用Ajax AutoCompleteExtender进行自动提示 [
This is my html code
<html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <div> <asp:TextBox ID="txtname" runat="server" OnTextChanged="txtname_TextChanged" AutoPostBack="True"> <asp:ScriptManager ID="ScriptManager1" runat="server"> <ajax:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="txtname" ServicePath="WebService.asmx" ServiceMethod="getname" MinimumPrefixLength="1" EnableCaching="true"> </div> </form> </body> </html>解决方案i think ur values starting from zero,if it is yes then please make it first value to one ya any character otherwise it will give a problem to fetching value from database
Refer this
Using Ajax AutoCompleteExtender for autosuggest[^]
这篇关于自动完成扩展程序不列出记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
