Book description
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
Table of contents
- A Note Regarding Supplemental Files
- Preface
-
I. Learning ADO
- 1. Introduction to ADO
- 2. The ADO Architecture
- 3. Accessing ADO with Various Languages
- 4. The Connection Object
-
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
- 7. The Command Object
- 8. The ADO Event Model
- 9. Data Shaping
- 10. Records and Streams
- 11. Remote Data Services
- 12. The Microsoft .NET Framework and ADO.NET
- II. Reference Section
-
III. Appendixes
- A. Introduction to SQL
- B. The Properties Collection
- C. ADO Errors
-
D. The ADO Data Control
- The ADO Data Control Property Pages
- Creating Connection Strings with the ADO Data Control
- The ADO Data Control Example
-
E. Enumeration Tables
- ADCPROP_ASYNCTHREADPRIORITY_ENUM Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ADCPROP_AUTORECALC_ENUM Enumeration — (Versions 2.1, 2.5, 2.6)
- ADCPROP_UPDATECRITERIA_ENUM Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ADCPROP_UPDATERESYNC_ENUM Enumeration — (Versions 2.5, 2.6)
- AffectEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- BookmarkEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- CommandTypeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- CompareEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ConnectModeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ConnectOptionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ConnectPromptEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- CopyRecordOptionsEnum Enumeration — (Versions 2.5, 2.6)
- CursorLocationEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- CursorOptionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- CursorTypeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- DataTypeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- EditModeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ErrorValueEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- EventReasonEnum — (Versions 2.0, 2.1, 2.5, 2.6)
- EventStatusEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ExecuteOptionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- FieldAttributesEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- FieldEnum Enumeration — (Versions 2.5, 2.6)
- FieldStatusEnum Enumeration — (Versions 2.5, 2.6)
- FilterGroupEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- GetRowsOptionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- IsolationLevelEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- LineSeparatorEnum Enumeration — (Versions 2.5, 2.6)
- LockTypeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- MarshalOptionsEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- MoveRecordOptionsEnum Enumeration — (Versions 2.5, 2.6)
- ObjectStateEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ParameterAttributesEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ParameterDirectionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- PersistFormatEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- PositionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- PropertyAttributesEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- RecordCreateOptionsEnum Enumeration — (Versions 2.5, 2.6)
- RecordOpenOptionsEnum Enumeration — (Versions 2.5, 2.6)
- RecordStatusEnum Enumeration — (Versions 2.0, 2.1, 2.6, 2.6)
- RecordTypeEnum Enumeration — (Versions 2.5, 2.6)
- ResyncEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- SaveOptionsEnum Enumeration — (Versions 2.1, 2.5, 2.6)
- SchemaEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- SearchDirectionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- SeekEnum Enumeration — (Versions 2.1, 2.5, 2.6)
- StreamOpenOptionsEnum Enumeration — (Versions 2.5, 2.6)
- StreamReadEnum Enumeration — (Versions 2.5, 2.6)
- StreamTypeEnum Enumeration — (Versions 2.5, 2.6)
- StreamWriteEnum Enumeration — (Versions 2.5, 2.6)
- StringFormatEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- XactAttributeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- Index
- Colophon
- Copyright
Product information
- Title: ADO: ActiveX Data Objects
- Author(s):
- Release date: June 2001
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781565924154
You might also like
book
Access 2007 Programming by Example with VBA, XML, and ASP
Access 2007 Programming by Example with VBA, XML, and ASP shows non-programmers how Access databases can …
book
Access 2003 VBA Programmer's Reference
Covers all features of VBA programming for Access database applications Begins with an overview of VBA …
book
Access™ 2007 VBA Programmer's Reference
This resource provides the tools you need to leverage Access 2007's built-in functionality and VBA in …
book
.NET Common Language Runtime Unleashed
The .NET Framework provides a runtime environment called the Common Language Runtime, which manages the execution …