Multi-Columns AutoComplete in a TextBox Using C# and SQL Server

2
465

multiAutocompleteSQLfig.3

Autocomplete plays an important role in searching for data or any records in the database. So, in this tutorial, I will teach you an advanced method of autocomplete in a textbox using C# and SQL Server. This method has the ability to get the records in every column of the table in the database. It is very helpful because you don’t have to exert much effort when retrieving data or records in the database.

 

Let’s begin:

 

Create a database in the SQL Server 2005 Express Edition and name it “dbplace“.

Create a table in the database that you have created.

After creating the database, open Microsoft Visual Studio 2008 and create a new windows form application for c#. Then, do the form just like this.

multiAutocompleteSQLfig.1

Go to the solution explorer and hit “code view” to fire the code editor.

multiAutocompleteSQLfig.2

In the code editor, declare all classes and variables that are needed.

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

After that, create a method for the autocomplete textbox.
Go back to the design view, establish a connection between SQL server and C#. Then, call a method of an autocomplete textbox.
Go back to the design view again, double-click the button and do the following code for saving the data in the database.
 

Output:

multiAutocompleteSQLfig.3

For all students who need a programmer for your thesis system or anyone who needs a source code in any programming languages. You can contact me @ :

 
Email – [email protected]
Mobile No. – 09305235027 – TNT

 

Download Source Code

Facebook Comments

2 COMMENTS

  1. What’s Happening i’m new to this, I stumbled upon this I have found It positively useful and it has aided me out loads. I am hoping to contribute & help other users like its aided me. Good job.

LEAVE A REPLY

Please enter your comment!
Please enter your name here