Autocomplete any character using textbox in C#

Question

Hi all,

 

I have  a datatable that include the data output as following:

{Apple, April, Orange, Lemon}

 

Currently, I'm using autocomplete method as below:

 

AutoCompleteStringCollection source = new AutoCompleteStringCollection(); 

DataTable dt = DataServiceMySQL.SearchCommandTextDataTable("SELECT `name` FROM `product`");

 

for (int i = 0; i < dt.Rows.Count; i++)
{
source.Add(dt.Rows[i][0].ToString());
} 

 

txtProduct.AutoCompleteMode = AutoCompleteMode.Suggest;
txtProduct.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtProduct.AutoCompleteCustomSource = source; 

 

But this method when you use the filter method, data output such as the following example:

Ex: when you input character 'a' then the data output: Apple and April.

     when you input chacter 'o' then the data output: Orange.

     when you input chacter 'l' then the data output: Lemon.

But I want to inout character 'e' then the data output: Apple, Orange.

 

Please help and thank you very much ^_^