Search Data From Database in GridView Without Writing Code

The following procedure shows how to create an application that searches for data in a database in a GridView without writing code.

 

Step 1

 

Go to a new project then select new project.

 

 

Right-click on the project (WebApplication2) then select Add New Item.

 

Step 2

 

 

Step 3

 

Drag & Drop one TextBox and one GridView.

 

 

Step 4

 

Add a data table as shown in the following images.

 

 

Step 5

 

Choose a data source type as in the following:

 

 

Step 6

 

Choose your data connection as in the following:

 

Step 7

 

Configure a select statement as in the following:

 

 

Step 8

 

Add a where clause as in the following:

 

 

 

Step 9

 

 

Step-Run

 

 

Step-Output