Contents
Introduction
Acknowledgements
What the Reader Should Know
Part 1 - ADO.NET Overview
Chapter 1 - Microsoft Database Technologies Past and Present
Chapter 2 -ADO.NET From Above
Chapter 3 - XML Aand ADO.NET
Chapter 4 - Setup for Examples
Part 2 - ADO.NET Basics
Chapter 5 - ADO.NET Data Providers
Chapter 6 - Basic Operations with the SQL Server Data Provider
Chapter 7 - Basic Operations with the OLE DB Data Provider
Chapter 8 - Writing Database Independent Code
Chapter 9 - Connection Objects
Chapter 10 - Command Objects
Chapter 11 - DataReader Objects
Chapter 12 - Binding Data
Chapter 13 - Working with Stored Procedures
Chapter 14 - Transactions
Chapter 15 - ADO.NET From the Web (ASP.NET)
Part 3 - The Dataset Class
Chapter 16 - What Are Datasets?
Chapter 17 - Using Datasets
Chapter 18 - The DATATABLE and DATAROW
Chapter 19 - Datarelations and Constraints
Chapter 20 - Custom Dataadapters
Chapter 21 - Querying the Dataset
Chapter 22 - Remoting Datasets
Part 4 - Datasets and Data Bound Controls
Chapter 23 - Data Bound Controls
Chapter 24 - The Datagrid Winform Control
Chapter 25 - The Datagrid Web Control
Chapter 26 - The Datalist Web Control
Chapter 27 - The Repeater Web Control
Chapter 28 - Dataviews
Part 5 - XML in ADO.NET
Chapter 29 - XML and ADO.NET
Chapter 30 - Relational Data as XML
Chapter 31 - XML as Relational Data
Chapter 32 - XPath Queries
Chapter 33 - SQL Server XML Features
Part 6 - Useful Extras
Chapter 34 - Connection Pooling
Chapter 35 - Reading Database Information
Chapter 36 - Prompting for Data Sources
Chapter 37 - Distributed Transactions