Ado Examples and Best Practices - page 1
- 1
- 2
- Table of Contents
- 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
- 1
- 2
