List of Figures

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