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
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Setting Connection Pooling Options
Navigating Between Parent and Child Records Using a DataRelation
Converting a DataReader to a DataSet
Populating a Windows Forms ComboBox
A.3. Structures
FileMaker Pro 8: The Missing Manual
Tables and Fields
Defining Fields
Lookups
Advanced Calculations
Copying Database Structure
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
Case #1 background: RailCo Ltd.
Case #2 background: Transit Line Systems Inc.
Service-orientation and contemporary SOA
WS-BPEL language basics
WS-Coordination overview
Microsoft WSH and VBScript Programming for the Absolute Beginner
Getting Started with the WSH and VBScript
Constants, Variables, and Arrays
Conditional Logic
Using Procedures to Organize Scripts
Using the Windows Registry to Configure Script Settings
InDesign Type: Professional Typography with Adobe InDesign CS2
Readability
Leading Menu Options and Keyboard Shortcuts
Contextual Alternates
Creating a Simple Drop Cap
Hyphenation Options
Special Edition Using FileMaker 8
Working Under the Hood
Troubleshooting
FileMaker Extra: Converting Web-Enabled Databases
Configuring and Administering FileMaker Server Using the SAT
Troubleshooting
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