Efficient way to implement text box autocomplete in windows

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!

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Arunava Bhattacharjee12y ago
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!