Efficient way to implement text box autocomplete in windows

Question

Is there any way to implement auto complete text box in the windows form application. I want to get the name from the table and table will contain millions of records. selecting all these record and assign as source to autocomplete will cause issue with performance. so i need suggestion on this.

Arunava Bhattacharjee · Answer

Of course there is a way. Autocomplete is an important requirement in business. http://www.dotnetfunda.com/articles/show/225/creating-autocomplete-textbox-in-windows-froms-using-csharp In your case you need to cache your tables. Many ways it can be done. You can have a static list to have all the data and then can load it whenever you want by LINQ. Depends on requirement. You need to first analyze the situation like how often you are calling the LoadData() method. Caching is the option I always look for when I see any table with large data accessed frequently for read-only. For windows form caching you can see this posts: http://msdn.microsoft.com/en-us/library/system.runtime.caching.memorycache.aspx http://www.codeproject.com/Articles/8977/Using-Cache-in-Your-WinForms-Applications Mark this as an accepted answer if you are happy with my solution!