Sams Teach Yourself ASP.NET in 21 Days, Second Edition By Chris Payne
Table of Contents
Day 8. Beginning to Build Databases
This workshop will help reinforce the concepts covered in today's lesson. The answers can be found in Appendix A.
What is a relational database?
What does SQL stand for, and what does it do?
What does ODBC stand for?
True or False: You can access any ODBC-compliant database through ASP.NET.
What are the five steps to accessing a database from ASP.NET?
Create your own database from scratch and use it to store information on pets that you've owned. (If you've never owned any, make some up!) What fields do you need?
Possible fields include pet name, pet type (dog, cat, and so on), years owned, and last vet visit. Don't forget to set a primary key. You can query the data using the SQL statements you've learned today.
Play with Listing 8.1 specifically, the DataList control. Modify the formatting tags in the template to see how you can change the display, and use what you know about ASP.NET server controls to change the properties of the DataList control.