Databases are very important to all applications, especially Web-based programs. Accessing data over the Internet is invaluable, and ASP.NET has made it simple to interface with any database. Today you learned about database fundamentals the differences between flat-file and relational databases, and ways to constrain and link your database tables. You then used Access 2000 to create a database that you'll use in your applications later. Next you took a brief look at SQL and the very important SELECT, INSERT, UPDATE, and DELETE statements, and you examined how to use them in your database tables. Finally, you looked at how to access data through a simple ASP.NET page, and you compared and contrasted data access with ASP.NET and traditional ASP. Tomorrow you're going to examine how to access and modify databases from ASP.NET, and you'll look at the data-centric server controls you skipped on Day 6. So far, you've only seen a tiny portion of ASP.NET's powerful database capabilities. As the week progresses, you'll start to use databases like an expert! |