title: How to set autocomplete feature from database using LINQ?
body: <p>I want to set the autocomplete feature to the textbox using LINQ. I already did in one way with sqlCommands. The code is </p>
  
  <pre><code>  OleDbCommand cmdinst = new OleDbCommand("select distinct cst_City from cstTable", con);
              OleDbDataReader drinst = cmdinst.ExecuteReader();
              AutoCompleteStringCollection instcol = new AutoCompleteStringCollection();
              while (drinst.Read())
              {
                  instcol.Add(drinst.GetString(0));
              }
              txtCity.AutoCompleteCustomSource = instcol;
  </code></pre>
  
  <p>With this I can add the autocomplecustom source to the textbox. Now I want to add the <strong>same feature with LINQ</strong>. Please any one help me..</p>