Editable Dropdownlist

You can use ajax autocomplete targeting textbox for this purpose:

MinimumPrefixLength="1"

CompletionInterval="100" CompletionSetCount="10"TargetControlID="Textbox1"ID="AutoCompleteExtender1" runat="server">

webservices method:

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

[System.Web.Services.WebMethod]

public static List Search(string prefixText, int count)

{

using (SqlConnection conn = new SqlConnection())

{

conn.ConnectionString = ConfigurationManager

.ConnectionStrings["con"].ConnectionString;

using (SqlCommand cmd = new SqlCommand())

{

cmd.CommandText = "select * from tablename where columnname like @Search+'%'";

cmd.Parameters.AddWithValue("@Search", prefixText);

cmd.Connection = conn;

conn.Open();

List detail= new List();

using (SqlDataReader sdr = cmd.ExecuteReader())

{

while (sdr.Read())

{

detail.Add(sdr["columnname"].ToString());

}

if (detail.Count == 0)

{

detail.Add("No data found");

}

conn.Close();

return detail;

}

also you can use jquery for this

Jquery Autocomplete

2 Replies

Know the answer? Post it — somebody with the same question will find it here.