Autocomplete Textbox Very Slow in C# Winform

Brinda Arumugam

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Brinda Arumugam12y ago
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 kumar12y ago
can you share your code present code