Ado

Author Jason Roff shows by example how to use ADO with your programming language of choice to save programming time, so you can concentrate on the content and quality of your application rather than the nitty-gritty of specific data formats.

ADO: ActiveX Data Objects includes:

• Chapters dedicated to the Connection, Recordset, Field, and Command objects and the Properties collection
• A complete, detailed reference listing every ADO object, method, property, and event, in convenient alphabetical order
• Chapters on ADO architecture, data shaping, the ADO Event Model
• An appendix containing enumeration tables used by ADO objects and collections, listed alphabetically
• Brief introductions to RDS, ADO.NET, and SQL

ADO: ActiveX Data Objects is a versatile one-stop guide to both the theory and practice of programming with ADO through Version 2.6. The thorough reference section and topic-specific chapters will help you find quick answers about the details of objects, collections, methods, and properties of ADO. And the abundance of practical code examples will give you a good grasp of how to use ADO's strong points most effectively.

Contents

• Preface

1. Introduction to ADO

• ADO in Context: Universal Data Access
• ADO and COM: Language Independence
• When to Use ADO
• Summary

• An Overview of the ADO Architecture
• ADO Components
• Summary

• Accessing ADO with Visual Basic
• Accessing ADO with Visual C++
• Accessing ADO with Visual J++
• Accessing ADO with VBScript
• Accessing ADO with JScript
• Summary

• 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

• Cursors: Viewing a Recordset
• Working with Recordsets
• Navigating a Recordset
• Working with Records
• Lock Types: Managing Access to a Recordset
• Summary

• The Fields Collection Object
• Field Specifics
• Determining Field Object Functionality
• Summary

• Specifying Commands
• Executing Commands
• Parameters
• The Parameters Project
• Asynchronous Execution
• Summary

• Introduction to Events
• The ConnectionEvent Family
• The RecordsetEvent Family
• Canceling Operations
• Turning Events Off
• Summary

• An Introduction to Data Shaping
• The Microsoft Data Shaping Service
• Shaping Commands
• Example: Accessing Shaped Recordsets
• Summary

• The Record Object
• The Stream Object
• Summary

• RDS Object Model
• An Example in RDS
• More Information About RDS
• Summary

• The Microsoft .NET Framework
• ADO.NET
• ADO.NET Features
• Summary

13. ADO API Reference

• Finding the Reference Page
• Using the Reference Pages

• A. Introduction to SQL
• B. The Properties Collection
• C. ADO Errors
• D. The ADO Data Control
• E. Enumeration Tables
• Index