ADO: ActiveX Data Objects Jason T Roff

Spis treści książki

• ADO: ActiveX Data Objects
• A Note Regarding Supplemental Files
• 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. Learning ADO
  • 1. 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
  • 2. 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
  • 3. 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
  • 4. 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
  • 5. 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
  • 6. 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
  • 7. 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
  • 8. 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
  • 9. 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
  • 10. 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
  • 11. 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
  • 12. 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. Reference Section
  • 13. 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, Connection.CommitTrans Method, Connection.RollbackTrans Method
      • 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, 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, Recordset.MoveLast Method, Recordset.MoveNext Method, Recordset.MovePrevious Method
      • 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. Appendixes
  • A. 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
  • B. The Properties Collection
    • The Property Example
  • C. ADO Errors
    • Working with Errors in ADO
      • ADO Trappable Errors
      • Data-Provider Errors
    • The Errors Example
      • The Main Form
      • The ADO Error(s) Form
  • D. 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
          • The Jet providers
          • The ODBC provider
          • The SQL Server providers
          • The Oracle providers
          • Other OLE DB providers
        • Entering advanced information
          • Impersonation level
          • Protection level
          • Connection timeout
          • Access permissions
        • Reviewing all of the Data Link information
      • Data Link Files
    • The ADO Data Control Example
  • E. 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
• Colophon
• Copyright

pokaż cały spis treści

ukryj recenzje