Sams Teach Yourself ASP.NET 2.0 in 24 Hours

Chapter 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, from a high-level perspective, what databases are, their internal structure, and their purpose. We looked at creating a database with SQL Server 2005 Express Edition through Visual Web Developer. We also saw how to create database tables and populate them with data.

Often we will want to retrieve information from a database and display it on an ASP.NET web page. To be able to do this, we need to learn how to retrieve ...