how to create and suggestionbox (textbox) using c#

Question

i want to create a suggestion box like in google. I want the data from database in suggestion box and i have created a dataset . i looked through all the properties of textbox and set AutoCompleteMode=SuggestAppend , AutoCompleteSource=CustomSource , and gave few values at AutoCompleteCustomSource (collection)
and it actually worked. What should i do to do the same using data from database?

Manish Mishra · Accepted Answer · 2013-03-08 11:26:21Z

3

take out the data from your db table, prepare a Collection and bind it to your controls AutoCompleteCustomSource through code.

see the code below:

public void BindAutoCompleteList(DataTable myDataTable)
{
     AutoCompleteStringCollection acDataSource= new  
     AutoCompleteStringCollection();
     foreach (DataRow row in myDataTable.Rows)
      {
         acDataSource.Add(row.Cells[0].Value.ToString());
      }


     txtBoxAuto.Clear(); 
     txtBoxAuto.AutoCompleteMode = AutoCompleteMode.Suggest;
     txtBoxAuto.AutoCompleteSource = AutoCompleteSource.CustomSource;
     txtBoxAuto.AutoCompleteCustomSource = acDataSource;
}

and call this BindAutoCompleteList() in the Form's constructor or any location suitable to your app.

where myDataTable consists of your db table rows

edited Mar 8, 2013 at 11:26

answered Mar 8, 2013 at 11:19

Manish Mishra

12.4k5 gold badges40 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to create and suggestionbox (textbox) using c#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related