20.10. Wrap-Up

This chapter introduced relational databases, SQL, ADO.NET and the IDE’s visual programming tools for working with databases. You examined the contents of a simple Books database and learned about the relationships among the tables in the database. You then learned basic SQL to retrieve data from, add new data to, and update data in a database.

We discussed the classes of namespaces System.Data and System.Data.SqlClient that allow programs to connect to a database, then access and manipulate its data. We also explained ADO.NET’s disconnected model, which enables a program to store data from a database temporarily in local memory as a DataSet.

The second part of the chapter focused on using the IDE’s tools and wizards to access ...

Get Visual Basic 2005 for Programmers: Deitel Developer Series, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.