Sams Teach Yourself ASP.NET 4 in 24 Hours: Complete Starter Kit

Hour 14. Accessing Data with the Data Source Web Controls

In this hour, we will cover

• Working with data source controls

• Understanding SQL, the language of databases

• Retrieving specific columns from a database table

• Returning database data that meets certain criteria

• Ordering the results of a database query

In the preceding hour we examined what databases are, their internal structure, and their purpose. We looked at creating a database with SQL Server 2008 Express Edition and saw how to create database tables and populate them with data.

Often we will want to retrieve information from a database and display it in an ASP.NET page. ASP.NET provides a set of Web controls—called data source controls—that are designed specifically to ...