ADO: ActiveX Data Objects
Published on 20. June 2001
620 pages
978-1-4919-3557-6 (ISBN)
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 collectionA complete, detailed reference listing every ADO object, method, property, and event, in convenient alphabetical orderChapters on ADO architecture, data shaping, the ADO Event ModelAn appendix containing enumeration tables used by ADO objects and collections, listed alphabeticallyBrief introductions to RDS, ADO.NET, and SQLADO: 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.
More details
Other editions
Additional editions
Book
07/2001
O'Reilly
€42.00
Shipment within 3-4 weeks
Content
- Intro
- Table of Contents
- Preface
- Introduction and Organization
- Part I: Learning ADO
- Part II: Reference Section
- Part III: Appendixes
- About the Book
- Audience
- Conventions Used in This Book
- Comments and Questions
- Acknowledgments
- I
- Introduction to ADO
- ADO in Context: Universal Data Access
- ODBC
- Jet/DAO
- RDO
- ODBCDirect
- OLE DB
- ADO
- RDS
- Putting It All Together
- ADO and COM: Language Independence
- COM
- ADO and COM
- When to Use ADO
- Summary
- The ADO Architecture
- An Overview of the ADO Architecture
- ADO Components
- The Connection Object
- The Command Object
- The Parameters collection and the Parameter object
- The Recordset Object
- The Fields collection and the Field object
- The Record Object
- The Stream Object
- The Properties Collection and the Property Object
- The Errors Collection and the Error Object
- Summary
- Accessing ADO with Various Languages
- Accessing ADO with Visual Basic
- Referencing ActiveX Data Objects
- Creating ActiveX Data Objects
- Using ADO with Visual Basic: An Example
- Accessing ADO with Visual C++
- Referencing ActiveX Data Objects
- Creating ActiveX Data Objects
- Using ADO with Visual C++: An Example
- Accessing ADO with Visual J++
- Referencing ActiveX Data Objects
- Creating ActiveX Data Objects
- Using ADO with Visual J++: An Example
- Accessing ADO with VBScript
- Referencing ActiveX Data Objects
- Creating ActiveX Data Objects
- Using ADO with VBScript: An Example
- Accessing ADO with JScript
- Referencing ActiveX Data Objects
- Creating ActiveX Data Objects
- Using ADO with JScript: An Example
- Summary
- The Connection Object
- Opening and Closing a Connection: Implicit Versus Explicit
- Opening a Connection
- Closing a Connection
- Configuring Connections
- Working with Connection Strings
- Working with Data Source Names
- Installing the DSNs
- Opening a connection with a DSN
- Setting Connection Options
- Default database
- Data-access permissions
- Timeout setting
- Cursor location
- Determining ADO Version Number and Connection State
- Choosing a Data Provider
- Executing Commands
- The Execute Method
- The CommandTimeout Property
- Managing Multiple Transactions
- Starting a Transaction: The BeginTrans and CommitTrans Methods
- Canceling a Transaction: The RollbackTrans Method
- Nesting Transactions
- Setting Transaction Options
- Automatic creation of new transactions
- Isolation level
- Determining the Layout of Your Data Source
- Summary
- The Recordset Object
- Cursors: Viewing a Recordset
- Dynamic Cursor
- Keyset Cursor
- Static Cursor
- Forward-Only Cursor
- CursorType Example
- Working with Recordsets
- The Open Method
- The Save Method
- Determining the State of the Recordset Object: The State Property
- Fine-Tuning Performance of the Recordset Object
- The CacheSize property
- The MaxRecords property
- The CursorLocation property
- Sorting, Filtering, and Finding Rows in a Recordset
- The Filter property
- The Sort property
- The Resync method
- The Find method
- Working with Multiple Recordset Objects
- Navigating a Recordset
- The Record Pointer
- The MoveFirst, MovePrevious, MoveNext, and MoveLast Methods
- The Move Example
- Ordinal Position
- Bookmarks
- The Move method
- Paging
- Working with Records
- Adding New Records
- Updating and Editing Records
- Deleting Records
- Retrieving Records
- Lock Types: Managing Access to a Recordset
- Read-Only Locks
- Pessimistic Locks
- Optimistic Locks
- Batch Optimistic Locks
- Summary
- Fields
- The Fields Collection Object
- The Field Object
- Working with the Fields Collection
- Field Specifics
- Field Datatypes
- Field Sizes
- Large Datatypes
- Batch Updates
- Determining Field Object Functionality
- Summary
- The Command Object
- Specifying Commands
- Textual Definitions as Commands
- Stored Procedures as Commands
- Table Names as Commands
- Unknown Command Types
- Executing Commands
- Executing Commands with the Command Object
- Executing Commands with the Connection Object
- Executing Commands with the Recordset Object
- Parameters
- Passing Parameters
- Parameter Properties
- Specifying Parameters
- The Parameters Project
- Asynchronous Execution
- Executing a Command Asynchronously
- Canceling a Command
- Summary
- The ADO Event Model
- Introduction to Events
- The ConnectionEvent Family
- Connection Events
- Execution Events
- Transaction Events
- Informational Events
- The RecordsetEvent Family
- Retrieval Events
- Movement Events
- Field Change Events
- Record Change Events
- Recordset Change Events
- Canceling Operations
- Turning Events Off
- Summary
- Data Shaping
- An Introduction to Data Shaping
- The Microsoft Data Shaping Service
- Shaping Commands
- APPEND Command
- COMPUTE Command
- Shape Functions
- Example: Accessing Shaped Recordsets
- Summary
- Records and Streams
- The Record Object
- Opening a Record Object
- Opening a Record object with a Command object
- Opening a Record object with a SQL statement
- Opening a Record object with a table name
- Opening a Record object with an open Recordset object
- Opening a Record object with a URL
- Navigating Hierarchies
- File and Directory Manipulation with the Record Object
- Copying
- Deleting
- Moving
- Record Object Properties
- Record Object Fields
- Internet Publishing provider fields
- Standard Record object fields
- The Stream Object
- Opening a Stream Object
- Obtaining a Stream with the Default Stream from a Record object
- Opening a Stream with an open Record object
- Opening a Stream with an absolute URL
- Opening a Stream in memory
- Reading and Writing with Streams
- Textual data
- Binary data
- Stream persistence
- Summary
- Remote Data Services
- RDS Object Model
- The DataSpace Object
- DataSpace object members
- Instantiating an object with the DataSpace object
- The DataFactory Object
- DataFactory object members
- Creating an empty recordset on the client side
- Roundtrip querying and updating
- The DataControl Object
- DataControl object members
- Binding a control to the DataControl object
- Filtering and sorting the recordset
- An Example in RDS
- More Information About RDS
- Summary
- The Microsoft .NET Framework and ADO.NET
- The Microsoft .NET Framework
- The Common Language Runtime
- C#: Unified Programming Language
- ASP.NET
- From COM to .NET: The Creation of ADO.NET
- ADO.NET
- DataSets
- Managed Providers
- ADO.NET Features
- Disconnected Data
- Strongly Typed Language
- XML Integration
- Summary
- II
- ADO API Reference
- Finding the Reference Page
- Using the Reference Pages
- Sample Object
- Sample Object.Property
- Sample Object.Method
- Command Object
- Command.ActiveConnection Property
- Command.Cancel Method
- Command.CommandStream Property
- Command.CommandText Property
- Command.CommandTimeout Property
- Command.CommandType Property
- Command.CreateParameter Method
- Command.Dialect Property
- Command.Execute Method
- Command.Name Property
- Command.NamedParameters Property
- Command.Parameters Collection
- Command.Prepared Property
- Command.Properties Collection
- Command.State Property
- Connection Object
- Connection.Attributes Property
- Connection.BeginTrans Method (Versions 2.0, 2.1, 2.5, 2.6) Connection.CommitTrans Method (Vers...
- Connection.BeginTransComplete Event
- Connection.Cancel Method
- Connection.Close Method
- Connection.CommandTimeout Property
- Connection.CommitTrans Method
- Connection.CommitTransComplete Event
- Connection.ConnectComplete Event
- Connection.ConnectionString Property
- Connection.ConnectionTimeout Property
- Connection.CursorLocation Property
- Connection.DefaultDatabase Property
- Connection.Disconnect Event
- Connection.Errors Collection
- Connection.Execute Method
- Connection.ExecuteComplete Event
- Connection.InfoMessage Event
- Connection.IsolationLevel Property
- Connection.Mode Property
- Connection.Open Method
- Connection.OpenSchema
- Connection.Properties Collection
- Connection.Provider Property
- Connection.RollbackTrans Method
- Connection.RollbackTransComplete Event
- Connection.State Property
- Connection.Version Property
- Connection.WillConnect Event
- Connection.WillExecute Event
- Error Object
- Error.Description Property
- Error.HelpContext Property (Versions 2.0, 2.1, 2.5, 2.6) Error.HelpFile Property
- Error.NativeError Property
- Error.Number Property
- Error.Source Property
- Error.SQLState Property
- Errors Collection
- Errors.Clear Method
- Errors.Count Property
- Errors.Item Property
- Errors.Refresh Method
- Field Object
- Field.ActualSize Property
- Field.AppendChunk
- Field.Attributes Property
- Field.DataFormat Property
- Field.DefinedSize Property
- Field.GetChunk Method
- Field.Name Property
- Field.NumericScale Property
- Field.OriginalValue Property
- Field.Precision Property
- Field.Properties Collection
- Field.Status Property
- Field.Type Property
- Field.UnderlyingValue Property
- Field.Value Property
- Fields Collection
- Fields.Append Method
- Fields.CancelUpdate Method
- Fields.Count Property
- Fields.Delete Method
- Fields.Item Property
- Fields.Refresh Method
- Fields.Resync Method
- Fields.Update Method
- Parameter Object
- Parameter.AppendChunk Method
- Parameter.Attributes Property
- Parameter.Direction Property
- Parameter.Name Property
- Parameter.NumericScale Property
- Parameter.Precision Property
- Parameter.Properties Collection
- Parameter.Size Property
- Parameter.Type Property
- Parameter.Value Property
- Parameters Collection
- Parameters.Append Method
- Parameters.Count Property
- Parameters.Delete Method
- Parameters.Item Property
- Parameters.Refresh Method
- Properties Collection
- Properties.Count Property
- Properties.Item Property
- Properties.Refresh Method
- Property Object
- Property.Attributes Property
- Property.Name Property
- Property.Type Property
- Property.Value Property
- Record Object
- Record.ActiveConnection Property
- Record.Cancel Method
- Record.Close Method
- Record.CopyRecord Method
- Record.DeleteRecord Method
- Record.Fields Collection
- Record.GetChildren Method
- Record.Mode Property
- Record.MoveRecord Method
- Record.Open Method
- Record.ParentURL Property
- Record.Properties Collection
- Record.RecordType Property
- Record.Source Property
- Record.State Property
- Recordset Object
- Recordset.AbsolutePage Property
- Recordset.AbsolutePosition Property
- Recordset.ActiveCommand Property
- Recordset.ActiveConnection Property
- Recordset.AddNew Method
- Recordset.BOF Property (Versions 2.0, 2.1, 2.5, 2.6) Recordset.EOF Property
- Recordset.Bookmark Property
- Recordset.CacheSize Property
- Recordset.Cancel Method
- Recordset.CancelBatch Method
- Recordset.CancelUpdate Method
- Recordset.Clone Method
- Recordset.Close Method
- Recordset.CompareBookmarks Method
- Recordset.CursorLocation Property
- Recordset.CursorType Property
- Recordset.DataMember Property (Versions 2.0, 2.1, 2.5, 2.6) Recordset.DataSource Property
- Recordset.Delete Method
- Recordset.EditMode Property
- Recordset.EndOfRecordset Event
- Recordset.EOF Property
- Recordset.FetchComplete Event
- Recordset.FetchProgress Event
- Recordset.FieldChangeComplete Event
- Recordset.Fields Collection
- Recordset.Filter Property
- Recordset.Find Method
- Recordset.GetRows Method
- Recordset.GetString Method
- Recordset.Index Property
- Recordset.LockType Property
- Recordset.MarshalOptions Property
- Recordset.MaxRecords Property
- Recordset.Move Method
- Recordset.MoveComplete Event
- Recordset.MoveFirst Method (Versions 2.0, 2.1, 2.5, 2.6) Recordset.MoveLast Method (Versions...
- Recordset.NextRecordset Method
- Recordset.Open Method
- Recordset.PageCount Property
- Recordset.PageSize Property
- Recordset.Properties Collection
- Recordset.RecordChangeComplete Event
- Recordset.RecordsetChangeComplete Event
- Recordset.RecordCount Property
- Recordset.Requery Method
- Recordset.Resync Method
- Recordset.Save Method
- Recordset.Seek Method
- Recordset.Sort Property
- Recordset.Source Property
- Recordset.State Property
- Recordset.Status Property
- Recordset.StayInSync Property
- Recordset.Supports Method
- Recordset.Update Method
- Recordset.UpdateBatch Method
- Recordset.WillChangeField Event
- Recordset.WillChangeRecord Event
- Recordset.WillChangeRecordset Event
- Recordset.WillMove Event
- Stream Object
- Stream.Cancel Method
- Stream.CharSet Property
- Stream.Close Method
- Stream.CopyTo Method
- Stream.EOS Property
- Stream.Flush Method
- Stream.LineSeparator Property
- Stream.LoadFromFile Method
- Stream.Mode Property
- Stream.Open Method
- Stream.Position Property
- Stream.Read Method
- Stream.ReadText Method
- Stream.SaveToFile Method
- Stream.SetEOS Method
- Stream.Size Property
- Stream.SkipLine Method
- Stream.State Property
- Stream.Type Property
- Stream.Write Method
- Stream.WriteText Method
- III
- Introduction to SQL
- Record Selection
- Selection Statements
- SELECT
- SELECT ALL
- SELECT DISTINCT
- SELECT DISTINCTROW
- SELECT TOP
- Aggregate Functions
- AVG
- COUNT
- MIN and MAX
- STDEV and STDEVP
- SUM
- VAR and VARP
- Setting Conditions
- WHERE
- WHERE
- Grouping and Ordering
- GROUP BY
- HAVING
- ORDER BY
- SELECT TOP
- Joining Tables
- INNER JOIN
- LEFT JOIN and RIGHT JOIN
- SELECT DISTINCTROW
- Subqueries
- Unions
- UNION
- Other Options
- PARAMETERS
- PROCEDURE
- WITH OWNERACCESS OPTION
- Data Manipulation
- Adding Records
- INSERT . . . INTO
- Modifying Records
- UPDATE
- Deleting Records
- DELETE
- Database Modification
- CREATE TABLE
- ALTER TABLE
- CONSTRAINT
- CREATE INDEX
- DROP
- The Properties Collection
- The Property Example
- ADO Errors
- Working with Errors in ADO
- ADO Trappable Errors
- Data-Provider Errors
- The Errors Example
- The Main Form
- The ADO Error(s) Form
- The ADO Data Control
- The ADO Data Control Property Pages
- Creating Connection Strings with the ADO Data Control
- Data Link Properties Dialog Box
- Entering provider information
- Entering connection information
- Entering advanced information
- Reviewing all of the Data Link information
- Data Link Files
- The ADO Data Control Example
- Enumeration Tables
- ADCPROP_ASYNCTHREADPRIORITY_ENUM Enumeration
- ADCPROP_AUTORECALC_ENUM Enumeration
- ADCPROP_UPDATECRITERIA_ENUM Enumeration
- ADCPROP_UPDATERESYNC_ENUM Enumeration
- AffectEnum Enumeration
- BookmarkEnum Enumeration
- CommandTypeEnum Enumeration
- CompareEnum Enumeration
- ConnectModeEnum Enumeration
- ConnectOptionEnum Enumeration
- ConnectPromptEnum Enumeration
- CopyRecordOptionsEnum Enumeration
- CursorLocationEnum Enumeration
- CursorOptionEnum Enumeration
- CursorTypeEnum Enumeration
- DataTypeEnum Enumeration
- EditModeEnum Enumeration
- ErrorValueEnum Enumeration
- EventReasonEnum
- EventStatusEnum Enumeration
- ExecuteOptionEnum Enumeration
- FieldAttributesEnum Enumeration
- FieldEnum Enumeration
- FieldStatusEnum Enumeration
- FilterGroupEnum Enumeration
- GetRowsOptionEnum Enumeration
- IsolationLevelEnum Enumeration
- LineSeparatorEnum Enumeration
- LockTypeEnum Enumeration
- MarshalOptionsEnum Enumeration
- MoveRecordOptionsEnum Enumeration
- ObjectStateEnum Enumeration
- ParameterAttributesEnum Enumeration
- ParameterDirectionEnum Enumeration
- PersistFormatEnum Enumeration
- PositionEnum Enumeration
- PropertyAttributesEnum Enumeration
- RecordCreateOptionsEnum Enumeration
- RecordOpenOptionsEnum Enumeration
- RecordStatusEnum Enumeration
- RecordTypeEnum Enumeration
- ResyncEnum Enumeration
- SaveOptionsEnum Enumeration
- SchemaEnum Enumeration
- SearchDirectionEnum Enumeration
- SeekEnum Enumeration
- StreamOpenOptionsEnum Enumeration
- StreamReadEnum Enumeration
- StreamTypeEnum Enumeration
- StreamWriteEnum Enumeration
- StringFormatEnum Enumeration
- XactAttributeEnum Enumeration
- Index
