title: how to search in combobox by database
body: <pre><code>protected void Page_Load(object sender, EventArgs e)
  {
      dr = new MySqlDataAdapter("select * from cus_mas_det", conn);
      ds = new DataSet();
  
      dr.Fill(ds, "cus_mas_det");
      DataTable CodeDesc = new DataTable();
      conn.Open();
      dr = new MySqlDataAdapter("select tvl_code, concat_ws(',', tvl_code, citi_name) citiname from code_desc where travel_mode = 'BUS'", conn);
      ds1 = new DataSet();
      dr.Fill(ds1);
      ddlfrom.DataSource = ds1;
      ddlfrom.DataTextField = "citiname";
      ddlfrom.DataValueField = "tvl_code";
      ddlfrom.DataBind();
      txtbookingdate.Text = System.DateTime.Now.ToString("yyyy/MM/dd");
      txtbookingdate.ReadOnly = true;
      txtbookingref.Text = autoid();
      txtbookingref.ReadOnly = true;
  }
  </code></pre>
  
  <p>I have a asp page in which I have textboxes and comboboxes, I am populating the combobox from the database, as given in the above code, and I am able to populate that.<br>
  Now my problem is I want to search the elemnets by typing any words in the combobox..<br>
  For example, if I type word "Ab" it should show all the elements starting with "Ab"..<br>
  How to do that? </p>
  
  <pre><code>   &lt;asp:ComboBox ID="ddlfrom" class="chzn-select" runat="server"  
                                              DataTextField="name" DataValueField="name" MaxLength="0" 
                                              style="display: inline;" 
                                              onselectedindexchanged="ddlfrom_SelectedIndexChanged1"&gt;
  
                                          &lt;/asp:ComboBox&gt;                                       
  </code></pre>