Searching Data in GridView Without Coding Using SQL Server

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