+612 9045 4394
Serious ADO : Universal Data Access with Visual Basic - Rob MacDonald

Serious ADO

Universal Data Access with Visual Basic

Book with Other Items Published: 17th August 2000
ISBN: 9781893115194
Number Of Pages: 611

Share This Book:

Book with Other Items

Ships in 5 to 9 business days

From seasoned developer and trainer Rob Macdonald comes Serious ADO: Universal Data Access with Visual Basic, which teaches experienced Visual Basic developers how to make the most of ADO, Microsoft's flagship product for database access. Serious ADO covers the full range of uses for ADO, from basic use of the ADO technology to specialized topics and advanced techniques that will benefit even the most experienced developers.

The first part of the book provides thorough coverage of ADO's components and what they can do. Along the way, Macdonald offers real-world code examples along with complete explanations of exactly what is occurring at each stage of the development process. This part also covers some of the key concepts upon which ADO programming is based, such as locking and transactions, connection pooling, marshalling, and Inter Process Communication, among others.

The second part of the book addresses the use of ADO in real-world development scenarios. Here, Macdonald demonstrates advanced user interface creation, including new ways to control the binding process. You'll also learn how to use Microsoft Transaction Server of COM+ applications to create transactional component-based systems.

ADO's Big Idea
The Look and Feel of ADO ADO Components and Libraries
ADO Unplugged
Recordset and Field Objects
Look, No Connection! - Creating a Standalone Recordset
Basic Recordset Navigation
Find, Sort, and Filter
Working with Pages
Modification Operations
ADO Data Types and Attributes
Data Types
Decimal and Numeric Data Types
Introducing Property Objects
Recordset Optimizations
Recordset Error Handling
Records ets Compared to Other Data Structures
The Data Structure Performance "Shoot-out"
Performance Tests Applied in the "Shoot-out"
The "Shoot-out" Results
Recordsets with SQL Data Sources
The Open Method
Staying Connected-Cursor Control
Forward-Only Cursor
Static Cursor
Keyset Cursor
Dynamic Cursor
Unspecified Cursor
Staying Connected-Lock Control
Read-Only Lock
Pessimistic Lock
Optimistic Lock
Batch Optimistic Lock
Examining the Fields Collection
Handling Null Data
Handling Large Data Fields
Handling Special Columns
Dynamic Field Properties
Modifications and Locking with Client-Side Cursors
Overcoming Missing Fields
Modifications Applied to Joins
Specifying a Unique Table
Resynchronizing Connected Recordsets
Using Index and Seek
Processing Multiple Recordsets
Optimization for SQL Data Sources
Append-only Recordsets
Cache Size
Explicit Connections
Creating and Using Connections
Data Link Files
Other Properties Used When Connecting
The Execute Method
Getting Schema Information
Connection Properties
ADO and Transactions
Programming Transactions with ADO
Concurrency and Isolation
ADO and Errors
Connection Pooling
A Two-Tier Pooling Scenario
An N-Tier Pooling Scenario
Explicit Commands
Why Use Command Objects?
Parameters and Parameter Objects
The Lazy Way to Use Parameters
The Inefficient Way to Use Parameters
Using Explicit Parameter Objects Efficiently
Commands with Multiple Parameters
Working with Stored Procedures
Stored Procedure Example
Stored Procedures with Multiple SELECT Statements
Stored Procedures and Temporary Tables
Command Optimizations
The ADO Event Model and Asynchronous Processing
Connection Events
Recordset Events
Strategies for Using Events
Asynchronous Processing
Opening a Connection Asynchronously
Cancelling an Asynchronous Command
Asynchronous Fetch with Client-side Cursors
Disconnected Recordsets
ADO in an N-Tier Environment
The Mechanics of Disconnecting
Batch Updating
Preprocessing a Batch Update
Postprocessing a Batch Update
Advanced Postprocessing
Resynchronizing Disconnected Recordsets
Disconnected Recordsets and Stored Procedures
Recordset Marshalling
Batch Updating Using an N-Tier Model
Recordset Persistence
Persisting with a Stream Object
Persisting Using the ASP Response Object
Persisting with a PropertyBag
Persisting with an MSMQ Message Body
Explicit Persisting
Recordset Recursion and Data Shaping
The Idea of Data Shaping
Creating the Connection String
Relation-based Hierarchies
Hierarchical Recordset Navigation
Generic Hierarchical Recordset Navigation
Updating Hierarchical Recordsets
Creating Complex Shapes Using Reshaping
Chapterless Child Recordsets
Avoiding Command Objects
Extending and Fabricating Recordsets Using Data Shaping
Fabricated Hierarchical Recordsets
Combining Provider and Fabricated Recordsets
Parameterized Data Shaping
External Parameters
Internal Parameters
Combining Internal and External Parameters
Group-based Hierarchies
Functions Supported by the COMPUTE Statement
Combining Group-based and Parameterized Relation-based Hierarchies
Working with Documents - Records and Streams
Semi -structured Data
The Internet Publishing Provider
The Record Object
Opening and Closing Records
Deleting, Moving, and Copying Resources
The GetChildren Method
Using Records and Recordsets
Opening, Closing, and Saving Streams
Uploading and Downloading Using Streams
Stream Content Manipulation
The ADO Data Definition Language and Security Model (ADOX)
The Death of DAO
Using ADOX
Working with Table Objects
Adding Tables into SQLServer
ADOX and Jet
Using ADOX Security Features with Jet
Creating Simple Providers
Why Do It?
The Simple Provider Interface
Creating a Read-only Provider
ReadingVB Source Code
Creating the Record Source Object Class
Creating the Data Source Object Class
Registering and Using Simple Providers
Creating an Updateable Provider
Supporting OLEDBSimple Provider Listeners
Implementing deleteRows
Implementing insertRows
Implementing set Variant
Data Shaping with Simple Providers
Binding and Data-aware Objects
Binding with Controls
Binding Programmatically
Using Format Objects
Binding to Controls and Properties That Are Not Data Aware
Binding with Classes
Creating a Nonvisual Data Consumer
The Data Repeater Control
Binding Hierarchical Recordsets
Displaying Complex Hierarchies
The Data Environment
What Is a Data Environment?
Building a Form Using Drag-and-Drop
Building a Form Using Explicit Binding
Using the Data Environment Programmatically
Adding Code to the Data Environment
Using Parameterized Commands
Executing Before Loading the Form
Executing After Loading the Form
Defining Hierarchical Recordsets
Making Data Environments into Components
What Are MTS and COM+?
Non-Transactional Components
Transactional Components
Connection-oriented vs. Transaction-oriented Systems
Creating Transactional Components Using ADO
Distributed Transactions
Controlling Secondary Objects in COM+
Controlling Secondary Objects in MIS
RDS and DHTML in Action
RDS Components and Architecture
The RDS DataControl
The RDS DataSpace
The RDSServer DataFactory
The MS Remote Provider
RDS Customization Handlers
Using RDS with Custom Business Objects
Multidimensional ADO (ADOMD)
OLAP and Multidimensional Data
The MDX Command Language
ADOMD - Dimensions and Axes
Working with a Three-dimensional Cellset
Creating Slices Using a WHERE Clause
Using ADODB Recordsets with OLAP Servers
Drill Down - Hierarchies, Levels, and Members
Defining Axes with Multiple Levels
ADOMD-aware Controls
Table of Contents provided by Publisher. All Rights Reserved.

ISBN: 9781893115194
ISBN-10: 1893115194
Series: Apress Ser.
Audience: General
Format: Book with Other Items
Language: English
Number Of Pages: 611
Published: 17th August 2000
Publisher: Apress
Country of Publication: US
Dimensions (cm): 23.32 x 19.25  x 3.43
Weight (kg): 1.07