C# : Searching Data in the Datagridview with SQL Server

0
3618

autocompleteCBOSQLfig.3
In this tutorial, I will teach you how to create an Autocomple in a Combobox using C#.net and SQL Server 2005. With this, it will suggest the records when you start to type in the combobox then, you don’t have to click anymore the dropdown or scroll down the list of records that you’re going to select.

 

Let’s begin:

 

Create a database and name it “dbcombo”.

After creating database, do the following query for creating a table in the database that you have created.

Now , open Microsoft Visual Studio 2008 and create new Windows Form Application for C#. Then do the following design of a Form as follows.

SearchDTGSQLfig.1

 

After that, go to the Solution Explorer, double click the “View Code”  to display the code editor.

SearchDTGSQLfig.2

 

 

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

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

 

After declaring the classes, establish a connection between SQL server and C#.net and retrieve the data in the database to display in the datagridview in the first load of the Form. 

 

Now, go back to the design views, double click the TextBox and do the following codes for searching data in the datagridview.

Output:

SearchDTGSQLfig.3

 

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

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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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