This article shows how to search data in a GridView using SQL Server without writing code.
Step 1
Go to "File" -> "New" -> "Project...".
![]()
Right-click on the project, WebApplication2, then select Add New Item.
![]()
Step 3
Drag & Drop one TextBox and one GridView.
![]()
Step 4
Add a data table as shown in the following image:
![]()
Step 5
Choose a data source type.
![]()
Step 6
Choose your data connection.
![]()
Step 7
Configure a select statement.
![]()
Step 8
Add a where clause.
![]()
![]()
Step 9
![]()
Step-Run
![]()
Output
![]()
![]()