Programming Books C Java PHP Python Learn more Browse Programming Books

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player

FREE Shipping on orders over $35.

Used - Good | See details
Sold by Von Melee.
Access codes and supplements are not guaranteed with used items.
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Microsoft® ADO.NET (Core Reference) (Developer Reference) [Hardcover]

David Sceppa
4.4 out of 5 stars  See all reviews (51 customer reviews)

Available from these sellers.

Free Two-Day Shipping for College Students with Amazon Student


Amazon Price New from Used from
Hardcover --  
Shop the new
New! Introducing the, a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Book Description

June 15, 2002 0735614237 978-0735614239

Microsoft ActiveX® Data Objects .NET (ADO.NET) is a set of libraries included with the Microsoft .NET Framework that helps you communicate with data from .NET-based applications—including XML data. Discover how to access, sort, and manipulate data in Web-enabled enterprise applications with this book. You’ll get expert guidance and insider tips from a leading database and ADO authority about how to write, test, and debug database code with the tools and wizards in Visual Studio .NET. You’ll also learn about the improved ADO.NET object model, its XML features for Web extensibility, its enhanced integration with Microsoft SQL Server™ 2000, and more.

Topics covered in this guide include:

  • Overview of ADO.NET
  • Building applications with the Data Form Wizard
  • Connecting to your database
  • Querying your database
  • Working with DataAdapters
  • Storing data in DataSets
  • Filtering and searching data in DataSets
  • Working with relational data
  • Submitting updates to your database
  • Advanced updating scenarios
  • Using strongly typed DataSets
  • Interacting with XML data
  • Building effective Windows® database applications
  • Building effective Web database applications


  • A fully searchable electronic copy of the book
  • Sample code in C# and Microsoft Visual Basic® .NET (also available from the link on this page)

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to

Editorial Reviews

About the Author

David Sceppa is a program manager on the SQL Server® team at Microsoft and an expert on ADO.NET. As a former technical lead in the Microsoft Developer Support group, he helped customers build database applications with Visual Basic and Microsoft Visual FoxPro®. David is MCSD certified in Microsoft .NET and has a background in teaching.

Product Details

  • Series: Developer Reference
  • Hardcover: 736 pages
  • Publisher: Microsoft Press (June 15, 2002)
  • Language: English
  • ISBN-10: 0735614237
  • ISBN-13: 978-0735614239
  • Product Dimensions: 0.8 x 7.3 x 9.1 inches
  • Shipping Weight: 2 pounds
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (51 customer reviews)
  • Amazon Best Sellers Rank: #1,478,659 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
38 of 39 people found the following review helpful
4.0 out of 5 stars Very good book on ADO.NET September 2, 2002
I read through the entire book over the course of about a day and a half. It is nice to find a technical book that is enjoyable to read.
This is currently the best ADO.NET book on the market. While there are a couple of areas where I believe some other books have provided better coverage (concurrency handling, for example), I know of no book that covers the whole of ADO.NET as well as this tome.
The flow of the book is very nice. Starting you out with DataConnections, the book logically moves through commands, readers, adapters and DataSets, which it further breaks down into its constituent parts. The last few chapters cover updates, transactions, XML and a few other advanced topics.
While the writing makes this book easier to read than the competition, I would not rate this as a beginner's book. If you are just getting into ADO.NET, and have not coded many data-driven apps, you will do well to revisit this book in a few months.
The strongest section in this book is probably the extensive coverage of the DataSet. Learning how to manipulate data with a DataSet is core to success with ADO.NET.
One of the biggest disappointments, for me, is the reliance on the System.Data.OleDb namespace. While certainly the most flexible, there should have been a few more SqlClient examples. In all fairness to the author, the SqlClient, OleDb and Oracle providers are covered in the Appendix. The author also warns you about differences between OleDb and SqlClient that you will have to take into account moving your code from one to the other.
I also wish the author had taken a little more time setting up a web application, as most of the application development I do is for the web.
Read more ›
Comment | 
Was this review helpful to you?
30 of 31 people found the following review helpful
4.0 out of 5 stars Very good August 19, 2003
Format:Hardcover|Verified Purchase
I bought this book only knowing a little about ADO.NET. I had been frustrated by other books' sterile explanations and examples that only include the most rudimentary data aware setup using wizards. But this one delivered, including a set of tutorials in the back that cover ADO.NET strategies for Windows, and Web/ASP VS.NET development. And not only did it cover setting up these strategies for using data aware components, but it stopped afterward and then admitted that in most cases you wouldn't use completely data aware solutions and it showed how to do the same thing manually in code. Now that is not what I expected.
So why only four stars instead of five? I got lost in the tutorials once. I was creating the app from scratch according to instructions when it deviated to overview of outstanding points of the code rather than exhaustive examination of the code. Then I had to open the sample projects and divine some of it from the code and compare to mine. That was probably my fault but it was distracting. Also the naming conventions are hungarian notation for some variables and control names (which is discouraged in newer C# VS.NET documentation) and the C# code had VB-type Pascal-case rather than correct Camel case. This is typical in most C# Microsoft documentation in books and online, which is obviously ported from VB to C# examples and doesn't follow documented recommended naming conventions (sorry, a pet peeve of mine).
Comment | 
Was this review helpful to you?
21 of 23 people found the following review helpful
5.0 out of 5 stars Can I give it 6 stars? March 10, 2003
Format:Hardcover|Verified Purchase
Ok, I have read a lot of good books on MS tech. I am myself a MCSD/MCDBA/MCSE, and I can tell you, it doesn't get much better than this.
Here is why.
First of all, I never review without reading a book cover to cover. I read this book cover to cover, and I love the way the author keeps the text anything from dull. I love it the way he puts in small jokes, which still are somewhat pertinent.
Secondly, I love it's practical touch. He points out specific problems that I have faced, and this book puts me right in the forefront as far as problems I will only know about, after having worked with ADO.NET hardcore for 2-3 years.
Thirdly, it's relevance. Most books start beating around the bush, atleast in certain topics they do. This book picks very pertinent issues, and gives practical explanations including criticisms as and when appropriate.
BUY IT. :)
Comment | 
Was this review helpful to you?
8 of 8 people found the following review helpful
4.0 out of 5 stars Good intro to ADO.Net programming March 14, 2003
This book was very instrumental in my leap from classic ADO to ADO.Net. The book is very easy to follow and gives good code examples. The book gives a great introduction to all the key principles of ADO.Net and won't leave you stranded without a clue.
The only downsides to this book are:
The book is written for both C# and VB.Net development and would have been very thin if not so. The book was a very quick read, only taking about 4 days to finish. More detail could have been given in the space taken. The other problem I had was that the cover of the book came unglued from the book when I was about 1/2 way through, which wasn't pleasing to say the least.
Lastly, some examples contain errors, which only slightly takes away from the greatness of the book.
Based on content and how easy it was to pick up on ADO.Net I have to give 4 stars.
Comment | 
Was this review helpful to you?
11 of 12 people found the following review helpful
5.0 out of 5 stars A must have for any serious developer July 29, 2003
I spent almost 8 months struggling with ADO .NET, bought a couple of books and just could't get it done efectively. Thank God for David Sceppa and this wonderful book.
From the very first page you start getting what's going on, and how you must get things done, no goofing around, just a very simple explanation of the concept, and then an example in both VB and C#, which is great because I'm thinking of moving away from VB and get into C#.
Every single object is clearly explained here, DataSets, DataTables, DataRows, Connections, Commands, DataReaders, DataAdapters, DataViews, and each of them's got all its proerties and methods thouroughly explained.
Before reading this book I was builduing an application with ADO .Net and it had the worst, dirtiest code you've ever seen, after reading this book, my code has reduced itself about 60%, and is cleaner, more understandable and it will be much easier to maintain.
There just can't be a better book to get up to speed with ADO .Net, it is really a must have.
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
4.0 out of 5 stars MCTS Visual Studio 2005
I bought this book because a friend recommended to me
This is a good book.
Delivery time was very long.
Published on August 31, 2009 by Marco Antonio Cisneros Lugo
5.0 out of 5 stars Not to be confused with Rebecca's Riordan's
This is the best ADO.NET out there. Do not confuse this with Rebecca's (that would be a tragedy).

This has in-depth coverage and has helped me so much, I can't thank... Read more
Published on May 31, 2006 by John Grove
4.0 out of 5 stars Not for the ADO novice but for those with a little hands on.
For approx. 1 year, I had been utilizing ADO.NET in a limited way. It confused me the switch from ADO to ADO. Read more
Published on February 23, 2006 by SpiritWnd
5.0 out of 5 stars Excellent Work
Unlike other tomes I have used, you walk away understanding the underlying principles after using this book. It was proofread and the code samples actually work. Read more
Published on March 23, 2005 by M. Inman
5.0 out of 5 stars Very complete. C# & code included with samples
The book will definitely show the ins/outs of getting connected to databases. The samples in the book show you how to use the drag-n-drop objects as well as using only code to... Read more
Published on February 19, 2005 by /dev/brian
5.0 out of 5 stars Easy Reading
After reading many tutorials and books on ADO.NET, I must say that this was the best one so far.

Not only does it explain everything there is to know about ADO. Read more
Published on January 25, 2005 by Dish
3.0 out of 5 stars Might be a good book, but I couldn't tell
I've read the reviews and the praises for this book and I want to believe them, but I could just never get into it. Read more
Published on November 23, 2004 by Andrew Baerst
4.0 out of 5 stars Es geçmeyin.
Ado.Net adına yazılmış ayrıntılı bir kitap sayılabilir. Yeni başlayanlar için, yada az bilgisi olanların faydalanbileceği bence etkili bir kitap. Read more
Published on September 25, 2004 by Yamac Yilmaz
4.0 out of 5 stars Great introduction to ADO.NET
This book provides a great introduction to ADO.NET. It covers the various aspects of connected and connectionless data access very well. Read more
Published on September 3, 2004 by critical_g
3.0 out of 5 stars index is hosed!
Nice book overall. Good code snippets and such. Unfortunately, the index is not 'aligned' correctly! Read more
Published on July 20, 2004 by R. Hatt
Search Customer Reviews
Search these reviews only

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category