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

0
141

autosuggestSQLPI

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.

autosuggestSQLPIfig.1

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

autosuggestSQLPIfig.2

  • 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.
 

 

Output:

autosuggestSQLPI

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

Facebook Comments

LEAVE A REPLY

Please enter your comment!
Please enter your name here