Chapter 1 Introduction

1. ADO.NET Data Providers
2. Connected and Disconnected Data

Chapter 2 .NET Data Providers

1. Data Providers
2. Selecting a Data Provider
3. Creating a Custom Data Provider

Chapter 3 Connections

1. Connection Object Overview
2. The Connection String
3. Opening and Closing Connections
4. Connection Pooling

Chapter 4 Commands

1. Command Object Overview
2. Creating and Executing a Command
3. Parameter Object Overview
4. Parameterized Commands
5. Commands with Stored Procedures
6. Commands and Data Definition Language (DDL)

Chapter 5 DataReaders

1. DataReader Object Overview
2. Performing a Query with a DataReader
3. Stored Procedures with the DataReader
4. DataReaders and Schema Information

Chapter 6 DataSets

1. Creating an Untyped DataSet
2. Working with Tables in the DataSet
3. Adding and Removing Relations
4. Adding Custom Information
5. Cloning the Schema
6. Copying the DataSet
7. Merging Two DataSets
8. Removing All Data
9. Resetting the DataSet
10. Committing and Discarding Changes

Chapter 7 DataTables

1. Creating a DataTable
2. Working with Columns
3. Constraints
4. Primary Key
5. Rows
6. Loading Data
7. Committing and Discarding Changes
8. Cloning the Schema of the Table
9. Copying the Table
10. Selecting a Subset of Rows
11. Performing Aggregate Calculations
12. Removing All Data
13. Resetting the Table
14. Identifying Errors in the Table
15. DataTable Events

Chapter 8 DataColumns

1. Creating DataColumns
2. Creating AutoIncrement Columns
3. Creating Expression Columns
4. Handling Null Values
5. Mapping .NET Data Provider Types to .NET Framework Types

Chapter 9 DataRows

1. Creating a DataRow
2. Updating Rows
3. Deleting Rows
4. Using Row State Information
5. Using Row Version Information
6. Accepting or Rejecting Changes to Rows
7. Navigating Parent and Child Rows
8. Using Row Error Information

Chapter 10 Constraints

1. Constraint Object Overview
2. The UniqueConstraint
3. The ForeignKeyConstraint

Chapter 11 DataRelations

1. DataRelation Object Overview
2. Navigating Relational Data

Chapter 12 DataViews and Data Binding

1. The DataView and DataViewManager
2. Sorting and Filtering
3. Accessing Data Through a DataView
4. Windows Data Binding
5. ASP.NET Data Binding

Chapter 13 Strongly Typed DataSets

1. Creating a Strongly Typed DataSet
2. Adding a Row
3. Editing a Row
4. Finding a Row
5. Null Data
6. Navigating Hierarchical Data
7. Annotations

Chapter 14 DataAdapters

1. Creating DataAdapter Object
2. Retrieving Data from the Data Source
3. Retrieving Schema Information from the Data Source
4. Updating the Data Source
5. Mapping Tables and Columns
6. AcceptChangesDuringFill
7. ContinueUpdateOnError
8. DataAdapter Events

Chapter 15 Updating the Data Source

1. SqlCommandBuilder Class Overview
2. Updating a Data Source Using Command Builder
3. Updating a Data Source Using Custom Logic
4. Refreshing Data After Updating
5. Retrieving Updated Values from the Data Source
6. Updating Data in Related Tables
7. Handling Concurrency Issues
8. Optimization

Chapter 16 Transactions

1. Manual Transactions
2. Isolation Levels
3. Savepoints
4. Nested Transactions
5. Transactions Using a DataAdapter
6. Automatic Transactions

Chapter 17 XML and the DataSet

1. DataSet XML Methods
2. Shaping DataSet XML
3. Other .NET XML Classes
4. XmlDataDocument Object Overview
5. Using the Data Objects to Edit XML
6. SQL Server 2000 XML

Chapter 18 The Connection Class

1. Comments/Troubleshooting
2. Properties Reference
3. Methods Reference
4. Events Reference

Chapter 19 The Command Class

1. Comments/Troubleshooting
2. Properties Reference
3. Collections Reference
4. Methods Reference

Chapter 20 The Parameter Class

1. Comments/Troubleshooting
2. Properties Reference

Chapter 21 The DataReader Class

1. Comments/Troubleshooting
2. Properties Reference
3. Methods Reference

Chapter 22 The DataSet Class

1. Comments/Troubleshooting
2. Properties Reference
3. Collections Reference
4. Methods Reference
5. Events Reference

Chapter 23 The DataTable Class

1. Comments/Troubleshooting
2. Properties Reference
3. Collections Reference
4. Methods Reference
5. Events Reference

Chapter 24 The DataColumn Class

1. Comments/Troubleshooting
2. Properties Reference
3. Collections Reference

Chapter 25 The DataRow Class

1. Comments/Troubleshooting
2. Properties Reference
3. Collections Reference
4. Methods Reference

Chapter 26 The Constraint Class

1. Comments/Troubleshooting
2. Properties Reference
3. Collections Reference

Chapter 27 The DataRelation Class

1. Comments/Troubleshooting
2. Properties Reference
3. Collections Reference

Chapter 28 The DataView Class

1. Comments/Troubleshooting
2. Properties Reference
3. Methods Reference
4. Events Reference

Chapter 29 The DataAdapter Class

1. Comments/Troubleshooting
2. Properties Reference
3. Collections Reference
4. Methods Reference
5. Events Reference

Chapter 30 The CommandBuilder Class

1. Comments/Troubleshooting
2. Properties Reference
3. Methods Reference

Chapter 31 The Transaction Class

1. Comments/Troubleshooting
2. Properties Reference
3. Methods Reference

Chapter 32 How to Use This Quick Reference

1. Finding a Quick-Reference Entry
2. Reading a Quick-Reference Entry

Chapter 33 Converting from C# to VB Syntax

1. General Considerations
2. Classes
3. Structures
4. Interfaces
5. Class, Structure, and Interface Members
6. Delegates
7. Enumerations

Chapter 34 The System.Data Namespace

Chapter 35 The System.Data.Common Namespace

Chapter 36 The System.Data.SqlClient Namespace

Chapter 37 The System.Data.OleDb Namespace

Chapter 38 The System.Data.SqlTypes Namespace