C# ComboBox AutoComplete Suggestions
<p>I've read a lot of post, but haven't really found anything to help with this problem. I want to select all cells from a database that contains the current text being type in the combobox.</p>

<p>But when I try it this way it only lets me enter 1 character at a time.</p>

<pre><code>private void GetSource(object sender, EventArgs e)
{
    var src = new AutoCompleteStringCollection();

    var tmp = _sqlite.GetDataTable("select customer from Machines");
    foreach (DataRow r in tmp.Rows)
    {
        if (r[0].ToString().Contains(CmbCustomer.Text))
            src.Add(r[0].ToString());
    }

    CmbCustomer.AutoCompleteCustomSource = src;

}
</code></pre>

<p>Is there a way of doing this? Thank in advance!</p>
