Data access technology has come a long way in the past decade. The introduction of Microsoft Access was a major step forward, followed by the giant leaps represented by ADO and now by ADO.NET.
ADO and ADO.NET Programming will help you use both APIS to write data access code that works perfectly, irrespective of the data source or front end. You'll learn to enlist ADO techniques in support of legacy systems, as well as in other scenarios where ADO is simply the better choice. And you'll master the special capabilities of ADO.NET, such as support for XML and disconnected data, that promise to make it the dominant data access API for years to come. Simple data retrieval and updating is only the beginning. Advanced topics include schema modification, data synchronization, and multidimensional aggregation.
This book also offers detailed coverage of source-specific and client-specific functionality, helping you tap into features unique to SQL Server, Oracle, and jet on the one hand, and Visual Basic, Access, and Excel on the other hand. You also get a practical introduction to the .NET Framework and appendices covering major object models.
On the CD
The enclosed CD contains all the book's sample code - both ADO code written in Visual Basic 6 and ADO.NET code written in Visual Basic .NET. You'll also find a primer on the SQL and MDX languages, as well as the MySQL database and a collection of ADO utilities.