sorting values in combobox by typing
<p>I have a combobox that is filled with data field <code>JobCode</code> from  database. There are 1000s of <code>jobcode</code> and when the user needs to select one <code>jobcode</code> he has to scroll down through all the <code>jobcode</code>s in the combobox. Can I do it in such a way that if the user types some letter of <code>jobcode</code> it will show the <code>jobcode</code>s which start with that letter in the combobox at the top of list so the user can select easily. For example, like adding some code in keypressevent in combobox.</p>

<p>The user must still choose from <code>jobcode</code>s in the list, not keep partially or incorrectly entered data that will cause wrong data entry at insert and update time.</p>

<pre><code>public void jobcomboboxload()
{
       OleDbConnection oleDbConnection1 = new System.Data.OleDb.OleDbConnection(connString);
       oleDbConnection1.Open();
       OleDbCommand oleDbCommand1 = new System.Data.OleDb.OleDbCommand("Select jobpk,jobcode from  jobcodemastertable", oleDbConnection1);
       OleDbDataReader reader = oleDbCommand1.ExecuteReader();
       DataTable dt = new DataTable();
       dt.Columns.Add("jobpk", typeof(int));
       dt.Columns.Add("jobcode", typeof(string));
       dt.Load(reader);
       cmbjobcode.ValueMember = "jobpk";
       cmbjobcode.DisplayMember = "jobcode";
       cmbjobcode.DataSource = dt.DefaultView;

       oleDbConnection1.Close();
   }
</code></pre>

<p><code>jobcode</code> is an unique field.</p>
