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.
bLuEmEzzy
0
Junior Poster in Training
Recommended Answers
Jump to PostHi,
You can try this:
For Each dr As DataRow In myDataSet.myTable.Rows Me.toolStripTextBox1.AutoCompleteCustomSource.Add(dr("myColumn").ToString()) NextMake sure you have your AutoCompleteSource set to CustomSource.
Jump to PostHi,
What I meant with " myColumn" is the name of the column you want to be added into the autocomplete textbox.
All 5 Replies
Luc001
77
Posting Whiz
Hi,
You can try this:
For Each dr As DataRow In myDataSet.myTable.Rows
Me.toolStripTextBox1.AutoCompleteCustomSource.Add(dr("myColumn").ToString())
NextMake sure you have your AutoCompleteSource set to CustomSource.
bLuEmEzzy
commented:
Thank u :)
+3
bLuEmEzzy
0
Junior Poster in Training
Thank u... still not working... i just check my code again.. God bless u :)
Luc001
77
Posting Whiz
Hi,
What I meant with " myColumn" is the name of the column you want to be added into the autocomplete textbox.
bLuEmEzzy
0
Junior Poster in Training
yeah that's what i did...
For Each dRow In ds.Tables(0).Rows
txt.AutoCompleteCustomSource.Add(dRow("Description").ToString
Nextjust checking my entire code esp my condition in retrieving record(s)... thanx...
bLuEmEzzy
0
Junior Poster in Training
yeah Luc001 Got it... http://www.daniweb.com/software-development/vbnet/threads/358691
thank you :) God bless u.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.