Editable Dropdownlist

Question

Hi Developers ! I need editable dropdown list for populate data from database in asp.net.

Rojalin Sahoo · Answer

You can use ajax autocomplete targeting textbox for this purpose: MinimumPrefixLength=1 CompletionInterval=100 CompletionSetCount=10TargetControlID=Textbox1ID=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

Rajeesh Menoth · Answer

Hi Check these given examples : 1) http://www.codeproject.com/Articles/290218/Custom-ASP-NET-Editable-DropDownList 2) http://www.c-sharpcorner.com/forums/thread/77369/editable-dropdownlist.aspx 3) http://www.aspdotnet-suresh.com/2015/04/populate-fill-dropdownlist-from-database-in-aspnet-using-csharp-vbnet.html