Autocomplete Textbox Very Slow in C# Winform

Question

Hi Everyone In my project i m using autocomplete textbox. i m binding the Phone no from database in autocomplete textbox. I have more than 500 records in my table (phone no table). it loading very slow in my method. how can i increase performance for autocomplete. if any one know solution for this plz just reply me... thanks & regards

Brinda Arumugam · Answer

OleDbCommand cmd1 = null; OleDbCommand cmd11 = null; namesCollection1.Clear(); cmd1 = new OleDbCommand(select * from InvoiceDetails Con); OleDbDataReader dr1 = cmd1.ExecuteReader(); while (dr1.Read()) { if (!namesCollection1.Contains(dr1[4].ToString())) { namesCollection1.Add(dr1[4].ToString()); } } cmd1.Dispose(); dr1.Dispose(); PhoneNoText.AutoCompleteMode = AutoCompleteMode.SuggestAppend; PhoneNoText.AutoCompleteSource = AutoCompleteSource.CustomSource; PhoneNoText.AutoCompleteCustomSource = namesCollection1;

venkata kumar · Answer

can you share your code present code