Programming Data-Driven Web Applications with ASP.NET

Summary

This chapter was only meant to give you a high-level overview of Structured Query Language to help you understand future chapters. You learned how to use SQL statements to do the following:

• Retrieve data from a database

• Organize the data before it's returned

• Use SubQuerys in your SQL statements

• Update data in a database

• Insert new data into a database

• Delete existing data from a database

I can guarantee that if you're participating in third-generation Web site development, you will be using Structured Query Language. This chapter demonstrated the use of page-level SQL statements, which isn't recommended when you're building your solution. We're using inline SQL primarily for simplicity.

Well, enough primers—let's get down to the nitty-gritty! ...