自动扩展器不工作 [英] Auto extender Not Working

问题描述

<asp:TextBox ID="txt_vech_no" runat="server"></asp:TextBox>

                                                        <cc1:AutoCompleteExtender ID="AutoCompleteExtender4" runat="server" TargetControlID="txt_vech_no" MinimumPrefixLength="1"

                                                             EnableCaching="true" CompletionSetCount="1" CompletionInterval="0" ServiceMethod="get_vehicleno"></cc1:AutoCompleteExtender>

[System.Web.Script.Services.ScriptMethod()]
       [System.Web.Services.WebMethod]
       public static List<string> get_vehicleno(string prefixText)
       {
           SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["BMS"].ToString());
           con.Open();
           SqlCommand cmd15 = new SqlCommand("select * from tbl_vehicle where vehicle_registration_no like @Name+'%'", con);
           cmd15.Parameters.AddWithValue("@Name", prefixText);
           SqlDataAdapter da15 = new SqlDataAdapter(cmd15);
           DataTable dt15 = new DataTable();
           da15.Fill(dt15);
           List<string> CountryNames12 = new List<string>();
           for (int i = 0; i < dt15.Rows.Count; i++)

           {

               CountryNames12.Add(dt15.Rows[i][1].ToString());

           }

           return CountryNames12;

       }

您好，我通过我的项目使用上面的autoextender代码，但它不适用于这个特定的textbox.please帮助我。

Hi im using the above code for autoextender through out my project but its not working for this perticular textbox.please help me out.

推荐答案

hi

您的TargetControlID是txt_vech_no，但是你传递了来自prefixText Textbox.So的值。对于我的建议你只需传递txt_vech_no代替prefixText并写下编码行为



cmd15.Parameters.AddWithValue（@ Name，txt_vech_no.Text.Trim（））;

hi
your TargetControlID is txt_vech_no but you passed the value from prefixText Textbox.So for my suggestion you just pass txt_vech_no in place of prefixText and write the line of coding as

cmd15.Parameters.AddWithValue("@Name", txt_vech_no.Text.Trim() );

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