Microsoft ADO. Net 2. 0 Step by Step

Introduction;
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;