我的自动完成扩展器无法正常工作 [英] my auto complete extender not working

问题描述

aspx.cs

aspx.cs

[System.Web.Services.WebMethod(),System.Web.Script.Services.ScriptMethod()]

   public static List<string> getagent(string prefix,int count,string contextkey)
   {
       SqlConnection conag = new SqlConnection(ConfigurationManager.ConnectionStrings["connect"].ConnectionString);
       SqlDataAdapter daag = new SqlDataAdapter("select AgentMainID from totalagent where AgentMainID like '" + prefix + "%'", conag);
       DataSet dsag = new DataSet();
       daag.Fill(dsag, "totalagent");
       List<string> totalagent = new List<string>();
       for (int i = 0; i < dsag.Tables["totalagent"].Rows.Count; i++)
       {
           totalagent.Add(dsag.Tables["totalagent"].Rows[i]["AgentMainID"].ToString());
       }
       return totalagent;
   }

aspx

aspx

<asp:ToolkitScriptManager ID="ToolkitScriptManager1"  runat="server">
    
<asp:Label ID="Label30" runat="server" style=" margin-left:150px" Text="Advisor Code">
        <asp:TextBox ID="txt_advisorcode" runat="server" style="margin-left: 149px" 
            Width="201px">
    <asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="txt_advisorcode"
     ServiceMethod="getagent" UseContextKey="true" MinimumPrefixLength="1" CompletionSetCount="1" EnableCaching="true" CompletionInterval="1"> 
    </string></string></string>

推荐答案

查看方法

see the method

[System.Web.Script.Services.ScriptMethod()]
    [System.Web.Services.WebMethod]
    public static string[] getagent(string prefixText, int count)
    {
       SqlConnection conag = new SqlConnection(ConfigurationManager.ConnectionStrings["connect"].ConnectionString);
        SqlDataAdapter daag = new SqlDataAdapter("select AgentMainID from totalagent where AgentMainID like '" + prefix + "%'", conag);
        DataSet dsag = new DataSet();
        daag.Fill(dsag, "totalagent");
        List<string> totalagent = new List<string>();
        for (int i = 0; i < dsag.Tables["totalagent"].Rows.Count; i++)
        {
            totalagent.Add(dsag.Tables["totalagent"].Rows[i]["AgentMainID"].ToString());
        }
        //Convert to Array as We need to return Array
        string[] prefixTextArray = totalagent.ToArray<string>();

        //Return Selected Products
        return prefixTextArray;
    } 
</string></string></string>

我更改了List< string> to string []

I changed List<string> to string[]

<cc1:autocompleteextender servicemethod="getagent" xmlns:cc1="#unknown">
    MinimumPrefixLength="1"
    CompletionInterval="0" EnableCaching="false" CompletionSetCount="10" 
    TargetControlID="txt_advisorcode"
    ID="autoCompleteExtender1" runat="server" FirstRowSelected = "false">
</cc1:autocompleteextender>

这篇关于我的自动完成扩展器无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！