See more Amazon Details

Contents Listing

Preface



I. Learning ADO



1. Introduction to ADO

ADO in Context: Universal Data Access

ADO and COM: Language Independence

When to Use ADO

Summary



2. The ADO Architecture

An Overview of the ADO Architecture

ADO Components

Summary



3. Accessing ADO with Various Languages

Accessing ADO with Visual Basic

Accessing ADO with Visual C++

Accessing ADO with Visual J++

Accessing ADO with VBScript

Accessing ADO with JScript

Summary



4. The Connection Object

Opening and Closing a Connection: Implicit Versus Explicit

Configuring Connections

Choosing a Data Provider

Executing Commands

Managing Multiple Transactions

Determining the Layout of Your Data Source

Summary



5. The Recordset Object

Cursors: Viewing a Recordset

Working with Recordsets

Navigating a Recordset

Working with Records

Lock Types: Managing Access to a Recordset

Summary



6. Fields

The Fields Collection Object

Field Specifics

Determining Field Object Functionality

Summary



7. The Command Object

Specifying Commands

Executing Commands

Parameters

The Parameters Project

Asynchronous Execution

Summary



8. The ADO Event Model

Introduction to Events

The ConnectionEvent Family

The RecordsetEvent Family

Canceling Operations

Turning Events Off

Summary



9. Data Shaping

An Introduction to Data Shaping

The Microsoft Data Shaping Service

Shaping Commands

Example: Accessing Shaped Recordsets

Summary



10. Records and Streams

The Record Object

The Stream Object

Summary



11. Remote Data Services

RDS Object Model

An Example in RDS

More Information About RDS

Summary



12. The Microsoft .NET Framework and ADO.NET

The Microsoft .NET Framework

ADO.NET

ADO.NET Features

Summary



II. Reference Section



13. ADO API Reference

Finding the Reference Page

Using the Reference Pages



III. Appendixes



A. Introduction to SQL



B. The Properties Collection



C. ADO Errors



D. The ADO Data Control



E. Enumeration Tables



Index