Viewing SQL Queries Results through the Web Matrix Project

When learning SQL, it helps to be able to run a SQL query against a database so that you can see the specific results returned by the SQL query. Fortunately, the Web Matrix Project makes this task quite simple. As we saw in the last hour, we can connect to a database system via the Web Matrix Project by first clicking the Data tab in the Workspaces pane and then clicking the New Connection icon.

In the previous hour we studied the Web Matrix Project's data features by creating a new database called ASPExamples, which contained a database table called Customers. In this hour we will run SQL queries against this database table. If you'd like to follow along by running the SQL queries on ...

Get SAMS Teach Yourself ASP.NET in 24 Hours now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.