Jason T. Roff has been programming computers since he was eight years old. He has been a programmer and developer for Blockbuster Entertainment and Isogon Corporation, where he quickly worked his way up from client/server developer to senior project leader. He is the author of Visual Basic 5 Database How-To.

• 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

Jason T. Roff has been programming computers since he was eight years old. He has been a programmer and developer for Blockbuster Entertainment and Isogon Corporation, where he quickly worked his way up from client/server developer to senior project leader. He is the author of Visual Basic 5 Database How-To.

• 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

Jason T. Roff has been programming computers since he was eight years old. He has been a programmer and developer for Blockbuster Entertainment and Isogon Corporation, where he quickly worked his way up from client/server developer to senior project leader. He is the author of Visual Basic 5 Database How-To.

• 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