Microsoft ADO. Net 2. 0 Step by Step

( 2 )


Teach yourself the fundamentals of ADO.NET 2.0—one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to start creating data centric applications for Microsoft Windows and the Web.

Discover how to:

  • Work in the Microsoft Visual ...
See more details below
Paperback (2005 ed.)
$35.87 price
(Save 10%)$39.99 List Price
Other sellers (Paperback)
  • All (52) from $1.99   
  • New (14) from $1.99   
  • Used (38) from $1.99   
Sending request ...


Teach yourself the fundamentals of ADO.NET 2.0—one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to start creating data centric applications for Microsoft Windows and the Web.

Discover how to:

  • Work in the Microsoft Visual Studio 2005 development environment
  • Use the ADO.NET 2.0 classes in either Visual Basic or Visual C#
  • Connect to and manipulate different data sources: Microsoft SQL Server, XML, OLE DB
  • Create ADO.NET objects at either design time or run time
  • Use visual design tools
  • Sort, filter, and manipulate data
  • Build data-bound Windows Forms and Web Forms
  • Work with validation controls
  • Read and write XML data and schemas

CD features:

  • Code samples
  • Sample databases

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Read More Show Less

Product Details

  • ISBN-13: 9780735621640
  • Publisher: Microsoft Press
  • Publication date: 12/14/2005
  • Series: Microsoft Step by Step Series
  • Edition description: 2005 ed.
  • Edition number: 2
  • Pages: 528
  • Product dimensions: 7.26 (w) x 9.26 (h) x 1.31 (d)

Meet the Author

With twenty years experience in the field, Rebecca M. Riordan has earned an international reputation for designing and implementing computer systems that are technically sound, reliable, and effectively meet her clients' needs. Her particular area of expertise is database design and she is a five year Access MVP. Rebecca has also authored several database books and served as a senior technical support engineer for Microsoft's database products. As a Microsoft employee in Australia, Rebecca was the Senior technical support engineer for Microsoft's database products.

Read More Show Less

Table of Contents

Who Is This Book For?;
The Organization of This Book;
Finding Your Best Starting Point in This Book;
Conventions and Features in This Book;
System Requirements;
Code Samples;
Prerelease Software;
Online Companion Content;
Support for This Book;
Part I: Getting Started with ADO.NET;
Chapter 1: Getting Started with ADO.NET;
1.1 On the Fundamental Interconnectedness of All Things;
1.2 The ADO.NET Object Model;
1.3 Creating a Simple Data-Bound Form;
1.4 Summary;
Part II: Data Provider Objects;
Chapter 2: Using Connections;
2.1 Understanding Connections;
2.2 Creating Connections;
2.3 Configuring Connections;
2.4 Connection Methods;
2.5 Summary;
Chapter 3: Using Data Commands and DataReaders;
3.1 Understanding Data Commands;
3.2 Creating Data Commands;
3.3 Configuring Data Commands;
3.4 Command Methods;
3.5 Understanding DataReaders;
3.6 Creating DataReaders;
3.7 DataReader Methods;
3.8 Summary;
Chapter 4: Using DataAdapters;
4.1 Understanding DataAdapters;
4.2 Creating DataAdapters;
4.3 Configuring DataAdapters;
4.4 Using DataAdapter Methods;
4.5 Responding to DataAdapter Events;
4.6 Summary;
Chapter 5: Transaction Processing in ADO.NET;
5.1 Understanding Transactions;
5.2 Using Transactions;
5.3 Creating Transactions;
5.4 Creating Nested Transactions;
5.5 Committing and Rolling Back Transactions;
5.6 Summary;
Part III: Data Provider Objects;
Chapter 6: Modeling a Database by Using DataSets and DataRelations;
6.1 Understanding DataSets;
6.2 Creating DataSets;
6.3 Configuring DataSets;
6.4 Using DataSet Methods;
6.5 Understanding DataRelations;
6.6 Creating DataRelations;
6.7 Configuring DataRelations;
6.8 Summary;
Chapter 7: Using DataTables;
7.1 Understanding DataTables;
7.2 Creating DataTables;
7.3 Configuring DataTables;
7.4 Creating DataColumns;
7.5 Configuring DataColumns;
7.6 Adding Constraints;
7.7 Creating DataRows;
7.8 Configuring DataRows;
7.9 Using DataTable Methods;
7.10 Using DataRow Methods;
7.11 Responding to DataTable Events;
7.12 Summary;
Chapter 8: Using TableAdapters;
8.1 Understanding TableAdapters;
8.2 Creating TableAdapters;
8.3 Configuring TableAdapters;
8.4 Using TableAdapter Methods;
8.5 Summary;
Chapter 9: Using DataViews;
9.1 Understanding DataViews;
9.2 Creating DataViews;
9.3 Configuring DataViews;
9.4 Using DataView Methods;
9.5 Summary;
Part IV: Manipulating Data;
Chapter 10: Editing and Updating Data;
10.1 Understanding the Editing and Updating Process;
10.2 Understanding DataRowStates and Versions;
10.3 Editing Data in a DataSet Under Program Control;
10.4 Updating Data Sources;
10.5 Summary;
Chapter 11: Manual Data Binding in Windows Forms;
11.1 Understanding Data Binding in Windows Forms;
11.2 Binding Controls to an ADO.NET Data Source;
11.3 Understanding the BindingContext Object;
11.4 Understanding the CurrencyManager Object;
11.5 Responding to CurrencyManager Events;
11.6 Understanding the Binding Object;
11.7 Configuring the Binding Object;
11.8 Using Binding Object Methods;
11.9 Responding to Binding Object Events;
11.10 Summary;
Chapter 12: Data Binding in Windows Forms by Using the BindingSource Component;
12.1 Understanding the BindingSource;
12.2 Creating BindingSource Components;
12.3 Configuring BindingSource Components;
12.4 Using BindingSource Methods;
12.5 Responding to BindingSource Events;
12.6 Summary;
Chapter 13: Using ADO.NET in Windows Forms;
13.1 Using the BindingNavigator to Navigate Through Data;
13.2 Displaying Data in Windows Controls;
13.3 Formatting Data;
13.4 Finding Data;
13.5 Validating Data in Windows Forms;
13.6 Using the ErrorProvider Component;
13.7 Summary;
Chapter 14: Basic Data Binding in Web Forms;
14.1 Understanding Data Binding in Web Forms;
14.2 Simple-Binding Web Controls to an ADO.NET Data Source;
14.3 Complex-Binding Web Controls;
14.4 Maintaining ADO.NET Object State;
14.5 Implementing Navigation;
14.6 Updating an Underlying Data Source;
14.7 Summary;
Chapter 15: Data Binding in Web Forms by Using the Data Source Component;
15.1 Understanding the Data Source Component;
15.2 Creating Data Source Components;
15.3 Configuring Data Source Controls;
15.4 Using Data Source Methods;
15.5 Responding to Data Source Events;
15.6 Summary;
Chapter 16: Data-Bound and Validation Controls;
16.1 Understanding Data-Bound Controls;
16.2 Understanding List Controls;
16.3 Understanding Template-Based Controls;
16.4 Understanding DataControlFields;
16.5 Understanding Validation Controls;
16.6 Summary;
Part V: ADO.NET and Other Types of Data;
Chapter 17: Reading and Writing XML;
17.1 Understanding XML Schemas;
17.2 Understanding ADO.NET and XML;
17.3 Using the DataSet XML Methods;
17.4 Controlling How XML Is Written;
17.5 Summary;
Chapter 18: The XmlDataDocument;
18.1 Understanding the XmlDataDocument;
18.2 Creating XmlDataDocuments;
18.3 Navigating an XML Document;
18.4 Using XmlDataDocument Methods;
18.5 Summary;
Chapter 19: Using ADO and ADOX in the .NET Framework;
19.1 Understanding COM Interoperability;
19.2 Understanding ADO in the .NET Framework;
19.3 Creating ADO Objects;
19.4 Using ADO Recordsets;
19.5 Understanding ADOX in the .NET Framework;
19.6 Summary;
Read More Show Less

Customer Reviews

Average Rating 4
( 2 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Posted February 11, 2009

    ADO.NET 2.0 Gives A Good Overall Understanding of Database Programming using Microsoft's .NET Framework

    Overall, it's a good book to have as a starting point. For the person who "tinkers" with programming. Programming professionals will want to start with a more advanced book.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted January 17, 2006

    A Step By Step Reach To the ADO Programming

    An Excellent book to do better ADO programming in the dot net environment.Book really helped to keep the pace high in learning.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)