any idea how to use autocomplete in the textbox getting the records from database? i tried using the properties of textbox. But if the table is updated then autocompleteCustomSource is not updated... please guide me.. thank u.


You can try this:

For Each dr As DataRow In myDataSet.myTable.Rows

Make sure you have your AutoCompleteSource set to CustomSource.

commented: Thank u :) +3

Thank u... still not working... i just check my code again.. God bless u :)


What I meant with " myColumn" is the name of the column you want to be added into the autocomplete textbox.

yeah that's what i did...

For Each dRow In ds.Tables(0).Rows

just checking my entire code esp my condition in retrieving record(s)... thanx...