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="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

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

Editable Dropdownlist

Answers (2)