8. Select the columns we need to bind to the GridView control and check Return only Unique rows if required. For the purpose of this exercise let us select StudentId and StudentName alone and click Next. The Test Query Screen appears. Click the test Query button to test the impact of the query we generated in the Select statement of the previous screen.

9. Now click on Finish and note that the Columns have been bound to the GridView control.

10. Check the paging, sorting and Delete Selection options if these functionalities are required. We will be dealing with this in greater detail a little later in this tutorial.

11. Now look at the code and see the impact on the source code.

Click here to view sample code

12. Now press F5 to execute the Gridview control page.

First Page: ASP.NET GridView Control