Flylib.com
Ado Examples and Best Practices
Ado Examples and Best Practices
ISBN: 189311516X
EAN: 2147483647
Year: 2000
Pages: 106
Authors:
William R. Vaughn
BUY ON AMAZON
Table of Contents
BackCover
ADO Examples and Best Practices
Introduction
Chapter 1: Working with ADO
What s New in ADO 2.5
The ADO Component Checker
Installing ADO
Deploying ADO
Getting More Help with ADO
Chapter 2: Introduction to ADO
The ADO Object Model
Chapter 3: Creating ADO Objects
Instantiating ADO Components in Visual Basic Script
Chapter 4: Getting Connected
The ADO Connection Object
Using the Connection Object
Managing Transactions
Chapter 5: ADO Command Strategies
Inner Workings of the Command Object
Building Command Objects
Managing Command Objects
Performance Considerations: Using Command Objects Wisely
Chapter 6: Recordset Strategies
Introducing Recordsets
Constructing Recordset Objects
Working with Recordset Objects
Filtering Out the Failed Rows
Using the Recordset Save Method
Chapter 7: Manipulating Your Recordset
Fetching Techniques
Sorting, Filtering, and Finding
Disconnecting Recordsets
Choosing Read-Only vs. Read-Write Recordsets
Working with Field Objects
Working with Stored Procedures
Accessing Deprecated Recordsets
Chapter 8: Passing Resultsets Between Layers
Delivering Pizza with a Dump Truck
Understanding Recordset Marshaling
Passing Disconnected Recordsets
Passing Strings and String Arrays
Passing Output Parameters instead of Rowsets
Passing Variant Arrays
Passing User-defined Structures
Passing Property Bags
Passing XML
Chapter 9: Web-based Solutions
Web Development 101
Using XML to Return Data from Web Pages
Managing Recordsets Using XML Stream Objects
Chapter 10: Getting Your Data into Shape
The Shape Provider
Building a Simple Shape
Why Not Use the Data Environment Designer?
Analyzing the Impact
Finding a Better Way
The Impact of the Just Enough Approach
Chapter 11: Data Access Tips and Techniques
TSQL Tips
Performance-Tuning Stored Procedures
SET NOCOUNT Using OLE DB Providers
Granting Permissions
More Recordset Secrets
Working with the Grid Control
Working with Strings
Working with Graphics
MDACADO Setup Issues
Hooking Up Visual BasicADO Help
Chapter 12: ADO and the Visual Database Tools
Using the Data View Window
Using the Data Environment Designer
Using ADO Without the Data Environment Designer
Using the Data Object Wizard
Chapter 13: SQL Server 2000 and ADO 2.6
SQL Server 2000 and the Application Developer
ADO Version 2.6
Appendix
Index
Index_B
Index_C
Index_D
Index_E
Index_F
Index_G
Index_H
Index_I
Index_J
Index_K
Index_L
Index_M
Index_N
Index_O
Index_P
Index_Q
Index_R
Index_S
Index_T
Index_U
Index_V
Index_W
Index_X
List of Figures
List of Tables
List of Sidebars
Ado Examples and Best Practices
ISBN: 189311516X
EAN: 2147483647
Year: 2000
Pages: 106
Authors:
William R. Vaughn
BUY ON AMAZON
Network Security Architectures
Applied Knowledge Questions
Security System Concepts
Impact of Network Security on the Entire Design
References
A Practitioners Guide to Software Test Design
Section I - Black Box Testing Techniques
Use Case Testing
Control Flow Testing
Data Flow Testing
Test Planning
An Introduction to Design Patterns in C++ with Qt 4
Setup: Win32
Class Definitions
Iterators
Iteration and the Visitor Pattern
Review Questions
Special Edition Using Crystal Reports 10
Positioning and Sizing Report Objects
Advanced Crystal Analysis Report Design
The Server Tier: Introduction to the Crystal Enterprise Framework
The Data Tier
Managing Crystal Enterprise System Settings
Java Concurrency in Practice
Building Blocks
Other Liveness Hazards
Example: Comparing Map Performance
Testing Concurrent Programs
Performance Considerations
Comparing, Designing, and Deploying VPNs
L2TPv3 Pseudowire Operation
Deploying MPLS Layer 3 VPNs
Review Questions
The Carriers Carrier Architecture
Understanding IPLS
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies