Posted 11 Jan 2010
Link to this post
I have a collection of over 2000 records that needs to be displayed in a combobox but due to it's size I can't load all 2000+ records. So I am implementing in a way that each time a character is typed in the combobox Text I requery the database with .StartsWith and take the first 10 matching records and use the result to bind the combobox. Everything is working well until when all characters match, then the combobox Text reset itself to blank. For example:
I have a list of airports in US. I type J and it gives me 10 airports starting with J, JF gives me 10 airports starting with JF. If I type JFK then there is only one matching airport and combobox contains only JFK, but the Text of the combobox resets to blank. I need ti to selected JFK instead.
Or better yet, if there is a solution for binding a large collection of data then the built in autocomplete functionality would solve the problem.