Auto Complete TextBox in VB.NET

You will want to get the contents from the db first, then put it on the array programatically. For example, you may not want to get the 10,000 records from the db, so you'll refill the contents of the array after each letter press with only the starting letters. Example: the user types 'a' on the text box, then you'll refill the contents of the array with data from the db which starts with 'a', and perhaps limit the number of records to get to 100 or so. the key here is not to get too few or too much data from db.