Autocomplete source from SQL
Posted on 2009-05-01
I'm building an autocomplete source from a SQL query where I want to grab both the ID column, as well as the description.
This will populate a text box, but to make it easier to retrieve, I'd love for each item to have some way to remain associated with it's ID, so that I can simply update my other table with the ID, as opposed to re-performing a search once the selection is made, in order to find out what it's ID is.
I know there were possibilities like this with vb6 (display member/ value member if memory serves me correctly).
Yet, is there a way to do this with a text box? I'm open to any suggestions...