Search Data From Database in GridView Without Writing Code

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

Step 1

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