Using ADO.NET in Web Forms
GRIDIEW
Add a DataGrid to a Web Form
Open the UsingWebForms project from the Start page or the File
menu.
In the Solution Explorer, double-click the DataGrid.aspx file.
Microsoft Visual Studio .NET opens the page in the form designer.
Select the DataGrid, and then click left corner the bottom
pane of the Properties window. and choose new data source
select new data source and press OK
Select New connection
change data source
Select datasource
Fill server Name name select are enter database name and press ok button
Save the connection and press OK button
Select columns from a table and press next button
Click Test query for preview data and press finish button
select datasource name
press F5 and run the program