• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 568
  • Last Modified:

How do I databind Autocomplete Collection of a Textbox to a database?

 I have a project that requires a fairly large (10,000 items) autocomplete list for various textboxes. I would prefer to have this list directly databound to a data source as opposed to iterating through a recordset and loading the list with a loop. The ability to apply a SQL query to this list is also very important.

  The AutocompleteCustomSource property of the textbox seems like a starting point but I am sketchy on the details of how to go about actually binding a datasource to it.

 Is this the way to go about this or am I misreading what the AutocompleteCustomSource property actually is used for?
0
kkamm
Asked:
kkamm
  • 2
1 Solution
 
arcrossCommented:
Not sure if this what you are lookng for..

http://msdn2.microsoft.com/en-us/library/801dxw2t(VS.80).aspx
0
 
kkammAuthor Commented:
Not really.

 I guess the crux of the matter is that I do not want to iterate through a returned dataset in order to load up the AutocompleteStringCollection list . I can do that in VB 6.

I would prefer the functionality of having the AutocompleteStringCollection list being directly bound to a data source. (In this case a SQL query)

So i guess the real question would be: is it possible to databind a Collection in VB.Net to a SQL query?
0
 
kkammAuthor Commented:
I went with a third-party .Net control from Skybound Software (http://www.skybound.ca/Products/AutoComplete/) which does what I need.
0
 
GranModCommented:
Closed, 500 points refunded.
GranMod
The Experts Exchange
Community Support Moderator of all Ages
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now