Auto-Suggest in a TextBox with SQL Server and C#



Searching an accurate information or record in the database is very difficult without a hard copy for your basis. So, in this tutorial, I will teach you how to create a  TextBox that has an auto-suggest with C# and SQL server. With this, TextBox will automatically suggest when you begin to type into it. This is very helpful in searching of records when you only knew is the initial letter of it.


Let’s begin;


  • Create a database and name it “dbname”.
  • Open Microsoft Visual Studio 2008 and create new Windows Form Application.
  • Do the following Form as follows.


  • Go to the Solution Explorer, double click the “View Code”  to display the code editor.


  • Declare all the classes and variables that are needed.

Note: Put using System.Data.SqlClient; above the namespace to access sql server library.

  • Go back to the design view, double click the Form and do the following code for making an auto-suggest TextBox and retrieving data in the SQL database.





For all students who need programmer for your thesis system or anyone who needs a sourcecode in any programming languages. You can contact me @ :
Email – [email protected]
Mobile No. – 09305235027 – tnt


Download Sourcecode

Looking for more source code? Type your keyword here here!


Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.