SAMS Teach Yourself ASP.NET in 24 Hours

Summary

In this hour we examined Structured Query Language, or SQL, which is the language used by all modern databases for retrieving, inserting, updating, and deleting data. This hour focused on retrieving database data by using both SQL and the data tools provided by the Web Matrix Project.

To retrieve rows from a database table, a SELECT statement is used, with the syntax

SELECT Column1, Column2, ..., ColumnN
FROM TableName
WHERE whereConditions
ORDER BY ColumnName
					

where the WHERE and ORDER BY clauses are optional.

Fortunately, we do not have to be SQL aficionados to retrieve database data in an ASP.NET Web page. As we saw in the “Constructing SQL Queries by Using the Web Matrix Project's Code Wizards” section, the Web Matrix Project provides ...