Ado: ActiveX Data Objects: Creating Data-Driven Solutions (Paperback)

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