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
Crystal Reports 9 on Oracle (Database Professionals)
Connectivity, Authentication, and Privileges
Oracle SQL
Other Tips
Data Dictionary Report
Appendix A Common Issues
SQL Hacks
Hack 40. Calculate Rank
Hack 43. Add Navigation Features to Web Applications
Hack 76. Compress to Avoid LOBs
Reporting
Hack 86. Set Up Queuing in the Database
MySQL Clustering
Ensuring That MySQL Cluster Works
Management Nodes
Benchmarking
Data Retrieval in MySQL Cluster
A MySQL Cluster Binaries
Data Structures and Algorithms in Java
Problems
Vocabulary
Quicksort
Projects
Graphs
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions
Getting Faster to Get Better Why You Need Both Lean and Six Sigma
Success Story #1 Lockheed Martin Creating a New Legacy
Seeing Services Through Your Customers Eyes-Becoming a customer-centered organization
Phase 1 Readiness Assessment
Phase 3 Mobilization
Python Programming for the Absolute Beginner, 3rd Edition
Why Python Here?
Generating Forward-Link Web Pages
Comparing Directory Trees
Configuring Widget Appearance
On Todays Menu: Spam, Spam, and Spam
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