ADO and ADO.NET Programming [Illustrated] [Paperback]

Mike Gunderloy (Author)

Book Description

Series: Transcend Technique | Publication Date: February 2002

ADO (ActiveX Data Objects) is Microsoft's key data access technology. It allows a programmer to connect to and manipulate data sources of all kinds, for both client/server and Web applications. It has been upgraded to ADO.NET for Microsoft's release of the .NET programming tools. ADO.NET can be used by programmers using Visual Basic, C# and any of the other .NET-compatible languages. ADO can also be used by Access programmers. This book covers both ADO and ADO.NET in one volume.

Editorial Reviews

From the Back Cover

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 Author

Mike Gunderloy has worked with every Microsoft data access technology, from the release of Access 1.1 right through ADO.NET. He's an 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.

Product Details

• Paperback: 1040 pages
• Publisher: Sybex Inc (February 2002)
• Language: English
• ISBN-10: 0782129943
• ISBN-13: 978-0782129946
• Product Dimensions: 9.1 x 7.5 x 2.2 inches
• Shipping Weight: 3.9 pounds (View shipping rates and policies)
• Average Customer Review: 3.7 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #2,842,440 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

2 of 3 people found the following review helpful:

4.0 out of 5 stars Great ADO.NET Learning Book and Reference, February 12, 2004

By 

Terry Smith "http://terrysmith.net -- http:/... (Little Rock, AR USA) - See all my reviews
(REAL NAME)   

This review is from: ADO and ADO.NET Programming (Paperback)

This is a very odd book in that eight of the chapters in this book cover ADO and nine cover .NET and ADO.NET (not including some extra chapters covering specific DB providers). You likely don't have much need for the ADO chapters, but the ADO.NET coverage is very good. The author gets to the point and has excellent step-by-step examples for both Windows Forms and ASP.NET. The later chapters give the best coverage I've seen for working with XML, reading XML from databases, synchronizing XML with datasets, etc. After reading it I still often refer back to this book as a reference.

0 of 1 people found the following review helpful:

5.0 out of 5 stars Excelent Coverage MS Data Access Technologies, June 24, 2004

By 

C. A. Sines "coreman76" (Columbus, Ohio United States) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: ADO and ADO.NET Programming (Paperback)

I picked this book up at a bargain price due to the print date/ success of the book. Let me tell you it was worth every penny and then some. The author has a good grasp on MS Data Access Technologies. The book is lengthy, but full of useful information. I even learned some things about the .NET architecture I didn't know by reading this book. Coverage is pretty in depth into both ADO and ADO.NET (OLE, ODBC, SQL its all covered). Example code is great to written in VB and VB.NET so C# programmers will have to extrapolate. Great book at an even better price!

3 of 6 people found the following review helpful:

2.0 out of 5 stars rehash of ado book, November 29, 2003

By 

"drcben4" (New York, NY USA) - See all my reviews

This review is from: ADO and ADO.NET Programming (Paperback)

This must be a rehash of an ADO book because it is full of ADO chapters and examples. Its like writing a book about commercial travel where most examples are about propeller planes - nothing wrong but most people today use jets and today almost all new Windows programming is about .net access methods.

So save your money and go somewhere else. Its a shame the author did not rewrite the entire book - it could have been the classic ADO.NET book.