Description
Book SynopsisGetting 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.N ET, 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.
Table of ContentsPreface 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
