ADO.NET is the primary API for data access within the .NET Framework. The set of classes that are used for data access did not change much in the upgrade from ADO.NET 1.0 to v2.0; what did change, though, was the process for database application development.
Murach's ADO.NET 2.0 Database Programming with VB 2005 introduces developers to ADO.NET 2.0, illustrates the steps necessary to build WinForms and ASP.NET database applications and explains how to manage database processing, data retrieval and database management.
Chapter 3, How to work with data sources and datasets, covers the basics of first creating and then using data sources. Creation is quite simple, thanks to the Data Source Configuration Wizard. Use, in this case, is demonstrated binding a DataGridView control and TextBox controls to a data source. The chapter concludes with some advice for data error handling and a brief look at the graphical Dataset Designer.
Excerpted from Murach's ADO.NET 2.0
Database Programming with VB 2005 (ISBN: 978-1-890774-43-1) by Anne Boehm.
Copyright © 2007. Published by Mike Murach & Associates, Inc., and available at your favorite book seller. Reprinted with permission.
More on ADO.NET programming
This was first published in September 2007