textbox autocomplete from database

[razekc]

Hello:

Using this post http://www.daniweb.com/software-development/vbnet/threads/358691/textbox-autocomplete-from-database (thks andeepparekh9) build a autocomplete.

Now i need show the id of my seleccion on the autocomplete on another textbox.

Some idea?
Thanks Regards

[poojavb]

So u need to show some id based on the selection of ur textbox to some other text box....
u need to add a select query based on ur auto complete text box in the text change event...

like

select * from tablename where colname='"+Autotextbox.Text+"'

later u need to declare a reader and assign the reader value to the other textbox

[razekc]

Hello:
I guess my question was poorly done.

My table has an id and name of the provider, with sandeepparekh9 article, I can see and select the provider's name, but I need to put in a text box the id of the selected provider

Thank you!