Introduction to ASP.NET 2.0 SqlDataSource Control - Adding a GridView to the Page
(Page 3 of 4 )
The SqlDataSource itself can't display the data on the page, it just represents the data to the page, or it's better to say that it represents data to Data-Bound Controls like the GridView control. So let's add a GridView control to the page and run it.
Drag a GridView control onto the page in the same way you did with the SqlDataSource, from the Data section of the Toolbox.
From the task menu of the GridView control select SqlDataSource1 from the drop-down list next to the Choose Data Source label. The following two screenshots represent the task menu before and after you select the SqlDataSource1 object as the data source for the GridView control.
Although that a discussion of the GridView control is beyond the scope of this article, note the difference between the first and the second screenshots. In the second screenshot you can configure the data source and you can enable Paging, Sorting and Selection. Also note that the columns have been changed to fit the returned result set of running the SELECT statement that has been set in the SqlDataSource control.
Now Let's run the page. Right click on the Default.aspx page in the Solution Explorer and select View in Browse.
The following result will be displayed in the page:
Without writing a single line of code we managed to connect to the database, execute a T-SQL statement and retrieve the results into a GridView control. So what really happened?
Next: What has been written for us by VS.NET 2005? >>
More ASP.NET Articles
More By Michael Youssef
