title: Adding items to TextBox AutoCompleteSource from database
body: <p>My textbox uses AutoComplete, I get the items from the database, however I have around 1000+ items and it's making the form load slowly because I loop through the data I selected and add it to the <code>AutoCompleteSource</code> 1 by 1.</p>
  
  <pre><code>sqlcmd = New SqlCommand("SELECT Column1 from Table", con)
  sqldr = sqlcmd.ExecuteReader
  TextBox1.AutoCompleteSource = AutoCompleteSource.CustomSource
  While sqldr.Read
      TextBox1.AutoCompleteCustomSource.Add(sqldr("Column1").ToString())
  End While
  </code></pre>
  
  <p>Is there a faster way of doing this?</p>