C# : Searching Data in the Datagridview with SQL Server

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.

autocompleteCBOSQLfig.3

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

ABOUT PROJECTPROJECT DETAILS
Project Name : Searching Data in the Datagridview with SQL Server
Project Platform :C#
Programming Language Used:C# Programming Language
Developer Name :itsourcecode.com
IDE Tool (Recommended):Visual Studio 2019
Project Type :Desktop Application
Database:MySQL Database
Upload Date and Time:June 19, 2016 – 8:30 am

Leave a Comment