
ADO: ActiveX Data Objects
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

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
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.