Search Data From Database in GridView Without Writing Code

In this article we will see how we can search for data in a 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