ADO: ActiveX Data Objects: Creating Data-Driven Solutions

by Jason Roff, Nancy Kotary (Editor)

Overview

Getting data across platforms and formats is a cornerstone of present-day applications development. ADO: ActiveX Data Objects is both an introduction and a complete reference to ADO (ActiveX Data Objects), Microsoft's universal data access solution. You'll learn how to easily access data in multiple formats—such as email messages, Access databases, Word documents, and SQL databases—even on different platforms, without spending extra time learning every last detail about each format. 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.

Product Details

ISBN-13:	9781565924154
Publisher:	O'Reilly Media, Incorporated
Publication date:	07/04/2001
Edition description:	1 ED
Pages:	618
Product dimensions:	7.00(w) x 9.19(h) x 1.18(d)

About the Author

Jason T. Roff has worn many hats with his extensive experience as a project manager, a software developer and a software architect. Roff's technical talents include expertise in C++, Java, ADO, Visual Basic, SQL Server, and object-oriented design.

Table of Contents

Preface; Introduction and Organization; Conventions Used in This Book; Comments and Questions; Acknowledgments; Learning ADO; Chapter 1: Introduction to ADO; 1.1 ADO in Context: Universal Data Access; 1.2 ADO and COM: Language Independence; 1.3 When to Use ADO; 1.4 Summary; Chapter 2: The ADO Architecture; 2.1 An Overview of the ADO Architecture; 2.2 ADO Components; 2.3 Summary; Chapter 3: Accessing ADO with Various Languages; 3.1 Accessing ADO with Visual Basic; 3.2 Accessing ADO with Visual C++; 3.3 Accessing ADO with Visual J++; 3.4 Accessing ADO with VBScript; 3.5 Accessing ADO with JScript; 3.6 Summary; Chapter 4: The Connection Object; 4.1 Opening and Closing a Connection: Implicit Versus Explicit; 4.2 Configuring Connections; 4.3 Choosing a Data Provider; 4.4 Executing Commands; 4.5 Managing Multiple Transactions; 4.6 Determining the Layout of Your Data Source; 4.7 Summary; Chapter 5: The Recordset Object; 5.1 Cursors: Viewing a Recordset; 5.2 Working with Recordsets; 5.3 Navigating a Recordset; 5.4 Working with Records; 5.5 Lock Types: Managing Access to a Recordset; 5.6 Summary; Chapter 6: Fields; 6.1 The Fields Collection Object; 6.2 Field Specifics; 6.3 Determining Field Object Functionality; 6.4 Summary; Chapter 7: The Command Object; 7.1 Specifying Commands; 7.2 Executing Commands; 7.3 Parameters; 7.4 The Parameters Project; 7.5 Asynchronous Execution; 7.6 Summary; Chapter 8: The ADO Event Model; 8.1 Introduction to Events; 8.2 The ConnectionEvent Family; 8.3 The RecordsetEvent Family; 8.4 Canceling Operations; 8.5 Turning Events Off; 8.6 Summary; Chapter 9: Data Shaping; 9.1 An Introduction to Data Shaping; 9.2 The Microsoft Data Shaping Service; 9.3 Shaping Commands; 9.4 Example: Accessing Shaped Recordsets; 9.5 Summary; Chapter 10: Records and Streams; 10.1 The Record Object; 10.2 The Stream Object; 10.3 Summary; Chapter 11: Remote Data Services; 11.1 RDS Object Model; 11.2 An Example in RDS; 11.3 More Information About RDS; 11.4 Summary; Chapter 12: The Microsoft .NET Framework and ADO.NET; 12.1 The Microsoft .NET Framework; 12.2 ADO.NET; 12.3 ADO.NET Features; 12.4 Summary; Reference Section; Chapter 13: ADO API Reference; 13.1 Finding the Reference Page; 13.2 Using the Reference Pages; Appendixes; Introduction to SQL; Record Selection; Data Manipulation; Database Modification; The Properties Collection; The Property Example; ADO Errors; Working with Errors in ADO; The Errors Example; The ADO Data Control; The ADO Data Control Property Pages; Creating Connection Strings with the ADO Data Control; The ADO Data Control Example; Enumeration Tables; Colophon;