Combo box binding slow - need to find code for autocomplete text box
Posted on 2006-11-06
I have unfortunately found after a long and arduous design of an application that I have to change code in almost every form because of a speed issue dealing with binding a particular combo box. I have a contact table with 12K records in it and reference that list in MANY forms. It take 4-5 seconds to bind using VB.NET 2005 and SQL Server Express. I have definitely narrowed it down to that. Talk about a sucker punch.....
I have another application that contains approximately 1K recs in it with no noticeable slowdown. So I continued down this merry road not knowing what was about to happen after loading these 12K recs.
I have to ask....is there no other way around having to change to an object other than a combo box? I've read other postings about breaking up or filtering the combo box but that is impossible.
If I have no other choice, my main question is this.....can anyone point me to a piece of code almost identical, if not identical, to the textbox completion of an email address as implemented in MS Outlook??? It's clean, requires only one key click, highlights the first row in a simple one-line border dropdown, backspace & tab keys work flawlessly.
Sick as a dog,