Javascript is not enabled in your browser. Enabling JavaScript in your browser will allow you to experience all the features of our site.

Learn how to enable JavaScript on your browser

Ado and Ado.Net Programming (Transcend Technique Programming Series)

by Mike Gunderloy

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

… See more details below

Overview
Product Details
Related Subjects

Overview

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.

There's more to ADO and ADO.NET than universal connectivity, of course. This book 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 and the SQL and MDX query languages on 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. These examples vividly illustrate the book's techniques and allow you to test their effectiveness and sharpen your own coding skills.

About the Authors
Mike Gunderloy has worked with every Microsoft data access technology, from the release of Access 1.1 right through ADO.NET. He'san independent consultant and frequent author on database topics. His other Sybex books include the Access 2002 Desktop and Enterprise Developer's Handbooks (with Paul Litwin and Ken Getz), SQL Server Developer's Guide to OLAP with Analysis Services, Visual Basic Developer's Guide to ADO, and Mastering SQL Server 2000. Mike lives on a farm in eastern Washington, where he raises chickens, llamas, and peacocks when he's not wrestling with new software releases.