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
Project Management JumpStart
Building the Foundation
Assessing Risk
Budgeting 101
Executing the Project
Appendix A Answers to Review Questions
Developing Tablet PC Applications (Charles River Media Programming)
The Tablet PC
Tablet PC Full Screen Utility
Creating an MP3 Player
Using Gestures to Control Tablet Media Player
Not Quite a Magic Ball
Special Edition Using Crystal Reports 10
Using the Report Creation Wizards
Understanding the Crystal Reports Gallery
Troubleshooting
Using Crystal Enterprise with NAT
Review of SQL Commands
PMP Practice Questions Exam Cram 2
Answers and Explanations
Answers and Explanations
Project PlanningCore Processes
Answers and Explanations
Answers and Explanations
Web Systems Design and Online Consumer Behavior
Chapter IV How Consumers Think About Interactive Aspects of Web Advertising
Chapter V Consumer Complaint Behavior in the Online Environment
Chapter VII Objective and Perceived Complexity and Their Impacts on Internet Communication
Chapter XII Web Design and E-Commerce
Chapter XVII Internet Markets and E-Loyalty
Python Standard Library (Nutshell Handbooks) with
The os Module
The copy Module
The urlparse Module
The SocketServer Module
The pwd Module
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