Home ProgrammingASP.NET AutoCompleteExtender in Textbox

AutoCompleteExtender in Textbox

by John Bhatt
461 views

Hi,We will learn how to enable AutoCompleteExtender in Textbox Control.

Here, We will learn to Map data from SQL Database to Textbox within Same Page. WebMethod in .cs Page.

ASPX Page Code

 <tr>
            <td class="style1">
                Vehicle No :
            </td>
            <td>
                <asp:TextBox ID="txtVehicleNo" runat="server" ToolTip="Enter Vehicle Number (Full)"
                    Width="168px"></asp:TextBox>
                <asp:AutoCompleteExtender ID="txtVehicleNo_AutoCompleteExtender" runat="server" DelimiterCharacters=""
                    Enabled="True" ServiceMethod="GetVehicleList" ServicePath="" TargetControlID="txtVehicleNo"
                    UseContextKey="True" MinimumPrefixLength="2">
                </asp:AutoCompleteExtender>
            </td>
        </tr>

Now Code in ASPX.CS Page

Add these Namespages for below Code.

using System.Data; // For Dataset
using System.Data.SqlClient; // For SQlConnection/Adaptor
using System.Configuration; // Access ConnectionString from Web.Config.
using System.Collections.Generic;
[System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
public static string[] GetVehicleList(string prefixText, int count, string contextKey)
{
  SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConToJohn"].ConnectionString);
  SqlDataAdapter adp = new SqlDataAdapter("Select distinct VehicleNo from VehicleDispatch where VehicleNo like '%" + prefixText + "%'", con);
  DataSet ds = new DataSet();
  adp.Fill(ds, "Vehicles");
  string[] VehicleNo = new string[ds.Tables["Vehicles"].Rows.Count];
  for (int i = 0; i <= ds.Tables["Vehicles"].Rows.Count - 1; i++)
  {
   VehicleNo.SetValue(ds.Tables["Vehicles"].Rows[0][0].ToString(), i);
  }
  return VehicleNo;
}

I have Selected Only Unique Value from Database using SELECT DISTINCT …. command. If you want all records, Simply Change SQL Query to SELECT ….. Will be glad to hear from you…

You may also like

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

AutoCompleteExtender in Textbox

by John Bhatt time to read: 1 min
0