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
Similar book on Amazon
CompTIA Project+ Study Guide: Exam PK0-003
ADO : ActiveX Data Objects
ADO Programmer's Reference
Serious ADO: Universal Data Access with Visual Basic
ADO 2.6 Programmer's Reference
OpenSSH: A Survival Guide for Secure Shell Handling (Version 1.0)
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
Introduction
ORM Constraints
Editing Logical Models”Intermediate Aspects
Change Propagation and Round Trip Engineering
Other Features and Best Practices
Beginning Cryptography with Java
Asymmetric Key Cryptography
Distinguished Names and Certificates
Key and Certificate Management Using Keystores
SSL and TLS
Appendix C Using the Bouncy Castle API for Elliptic Curve
Java for RPG Programmers, 2nd Edition
Javas Language And Syntax
Data Types And Variables
An Object Orientation
Exceptions
More Java
101 Microsoft Visual Basic .NET Applications
Working with Microsoft Visual Studio .NET 2003 and Microsoft .NET Framework 1.1
Working with Console Applications
Advanced .NET Framework
Visual Studio .NET
Securing Applications
Special Edition Using Crystal Reports 10
Using the Chart Expert
Using Variables to Pass Data Between Reports
Recently Added or Changed OLAP Features in Crystal Reports
What Is the Crystal Repository?
Troubleshooting
VBScript in a Nutshell, 2nd Edition
What VBScript Is Used For: Gluing Together Objects
Functions and Procedures
The Outlook Object Model
Section A.14. Program Structure and Flow
Section B.5. Error Constant
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