title: Searchable Dropdown list in Asp.net
body: <pre><code>SqlConnection myDBCon = new SqlConnection(sc); 
  SqlCommand command = new SqlCommand("select  Caption_name from Commercial_caption", myDBCon);
  myDBCon.Open();
  SqlDataAdapter mySqlAdapter = new SqlDataAdapter();
  mySqlAdapter.SelectCommand = command;
  DataSet ds = new DataSet();
  mySqlAdapter.Fill(ds);
  DropDownList1.DataSource = command.ExecuteReader();
  DropDownList1.DataTextField = "Caption_name";
  DropDownList1.DataBind();
  DropDownList1.Items.Insert(0, new ListItem("--SELECT--","0"));
  myDBCon.Close();
  </code></pre>