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
ERP and Data Warehousing in Organizations: Issues and Challenges
ERP System Acquisition: A Process Model and Results From an Austrian Survey
The Second Wave ERP Market: An Australian Viewpoint
Enterprise Application Integration: New Solutions for a Solved Problem or a Challenging Research Field?
Healthcare Information: From Administrative to Practice Databases
Development of Interactive Web Sites to Enhance Police/Community Relations
High-Speed Signal Propagation[c] Advanced Black Magic
Concentric-Ring Skin-Effect Model
Useful Fourier Transform-Pairs
Differential and Common-Mode Velocity
Glossary of Cabling Terms
Nature of EMC Work
Metrics and Models in Software Quality Engineering (2nd Edition)
Criteria for Model Evaluation
The PTR Arrival and Backlog Projection Model
In-Process Metrics and Reports
Halsteads Software Science
Keep It Simple or Face Decomplexification
Developing Tablet PC Applications (Charles River Media Programming)
Strings, GDI+, and Error Handling in VB .NET
Your First Program
Tablet PC Full Screen Utility
Creating an MP3 Player
Pong Game
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
IOS Images and Configuration Files
Virtual Terminals (VTYs)
Asynchronous Interfaces
BGP Confederacies
A.2. OSI Reference Model
Microsoft WSH and VBScript Programming for the Absolute Beginner
Overview of the Windows Script Host
Conditional Logic
Using the Windows Registry to Configure Script Settings
Appendix B Built-In VBScript Functions
Appendix C Whats on the CD-ROM?
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