Flylib.com
List of Figures
Previous page
Table of content
Next page
Team-Fly
Chapter 2: Introduction to ADO
Figure 2-1: ADO connecting to OLE DB
Figure 2-2: OLE DB Providers as exposed by the Data Link Properties dialog box
Figure 2-3: The ADO 2.5 Object Model
Chapter 3: Creating ADO Objects
Figure 3-1: The Visual Basic IDE Project/References dialog box
Chapter 4: Getting Connected
Figure 4-1: OLE DB Providers
Figure 4-2: Using the Data Link Properties dialog box to build a Connection String
Figure 4-3: The ADODC Property Page after the ConnectionString is built
Figure 4-4: Use the SQL Server 7.0 Client Network Utility to select an alternative protocol.
Figure 4-5: Be sure to set the prompting level to avoid exposing this dialog box.
Figure 4-6: The Visual Basic 6.0 Data View window
Figure 4-7: The Data Environment Designer exposing a stored procedure dragged from the Data View window.
Figure 4-8: Using the Data View window to create a new Data Link
Figure 4-9: Using the ODBC Data Source Administrator to select connection pooling options.
Figure 4-10: Using the SQL Server Profiler to trace TSQL querie
Chapter 5: ADO Command Strategies
Figure 5-1: Direction property enumerated constants
Figure 5-2: The VB IDE prompting with a list of ADO datatypes
Chapter 6: Recordset Strategies
Figure 6-1: VDT Query Designer
Chapter 7: Manipulating Your Recordset
Figure 7-1: Set the MSHFlexGrid1.Recordset to your Recordset to display the rowset.
Figure 7-2: Use Debug.Print to display the Recordset field names and values in the Immediate window.
Figure 7-3: The Visual Basic IDE exposes the Recordset Events.
Figure 7-4: Examining the Locals Window GetRows Variant Array
Figure 7-5: The Sort, Filter, and Find example user interface
Figure 7-6: Handling multiple result sets returned from stored procedures
Figure 7-7: Right-click the Object Browser and select "Show hidden members" to see deprecated objects such as Recordset21.
Chapter 8: Passing Resultsets Between Layers
Figure 8-1: Presenting the rows on the client
Chapter 9: Web-based Solutions
Figure 9-1: Capturing parameters from a Web page and invoking an ASP
Figure 9-2: Returning XML from an ASP via URL reference to pass a Recordset
Chapter 10: Getting Your Data into Shape
Figure 10-1: Hierarchy constructed by Data Environment Designer
Figure 10-2: Author "parent" rows and associated TitleAuthor "child" rows
Figure 10-3: Using bound TextBox controls with the MSHFlexGrid
Figure 10-4: An MSHFlexGrid populated from a Data Environment Designer-generated query
Figure 10-5: The Data Environment Designer Connection (Visual Basic) property page
Chapter 11: Data Access Tips and Techniques
Figure 11-1: Using SQL Enterprise Manager to add a new remote server
Chapter 12: ADO and the Visual Database Tools
Figure 12-1: Visual Basic 6.0 Data View Window-adding a new Data Link
Figure 12-2: Visual Basic 6.0 Data View window-a typical database diagram
Figure 12-3: The Visual Basic 6.0 Data Environment Designer with Four Commands
Figure 12-4: The Data Environment Designer's query editor
Figure 12-5: The Data Environment Designer Property page where you set prompt behavior
Team-Fly
Previous page
Table of content
Next page
Ado Examples and Best Practices
ISBN: 189311516X
EAN: 2147483647
Year: 2000
Pages: 106
Authors:
William R. Vaughn
BUY ON AMAZON
Project Management JumpStart
Developing Project Management Skills
Assessing Risk
Developing the Project Plan
Budgeting 101
Controlling the Project Outcome
CompTIA Project+ Study Guide: Exam PK0-003
IT Project+ Study Guide
IT Project Management Overview
Project Initiation
Scope Planning
Cost Planning
Absolute Beginner[ap]s Guide to Project Management
Next Step in the Schedule Development Process
Controlling a Project
Options for Issue Log
Best Practices
The Essential Process for Managing Project Risks
VBScript Programmers Reference
Classes in VBScript (Writing Your Own COM Objects)
Script Encoding
Appendix B Variable Naming Convention
Appendix F The Scripting Runtime Library Object Reference
Appendix K The Variant Subtypes
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Local Area Network (LAN) Technologies
Internet Protocol (IP) Basics
Internet Protocol Version 6 (IPv6)
File and Printer Sharing
Internet Information Services (IIS) and the Internet Protocols
Programming Microsoft ASP.NET 3.5
Working with the Page
Working with Web Services
Creating New ASP.NET Controls
Design-Time Support for Custom Controls
HTTP Handlers and Modules
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