FMS Facebook Page
Jump: Search:

Total Visual SourceBook

Total Visual SourceBook CD and Printed Manual

Microsoft Access 2007/2010 Version
is Shipping!

New features in Total Visual SourceBook for Access, Office 2007 and VB6

Supports Access/Office 2010 (32 bit), 2007, 2003, 2002, 2000, and
Visual Basic 6.0!

Also available for:
Access 97/95

View all FMS products for Microsoft AccessAll Our Microsoft Access Products

SourceBook Info:

Why SourceBook?

 

"The code is exactly how I would like to write code and the algorithms used are very efficient and well-documented."

Van T. Dinh, Microsoft MVP

 

 

 

 

 
Royalty free source code library modules for Microsoft Access, VB6, VBA, OfficeRoyalty free source code library modules for Microsoft Access, VB6, VBA, OfficeVBA and VB6 Source Code Library Download the free trial version of Total Visual SourceBook for Microsoft Access, Office, VB6 and VBA
Category: Database : SQL Server
Description: Working with SQL Server database objects

Module: modSnippetADOSQLServerRst

Example code that shows how to work with SQL Server recordsets via ADO

Procedure Name

Type

Description

(Declarations) Declarations Declarations and private variables for the modSnippetADOSQLServerRst module
ShowSQLADOHierarchicalRecordset Procedure Create a "shaped" hierarchical recordset using the MSDATAShape OLEDB provider
ShowSQLADORecordsetCommandExecute Procedure Open an ADO recordset with an existing connection using the execute method of an ADO command object to create a read-only recordset from a named table.
ShowSQLADORecordsetCommandExplicitParameters Procedure Create a simple command object using the existing connection. Create explicit parameters and supply the values via the parameter object. Open the recordset from this command.
ShowSQLADORecordsetCommandFromStoredProcMultiple Procedure Create a recordset object from a stored procedure that creates three resultsets.
ShowSQLADORecordsetCommandMultiple Procedure Create a recordset from an ADO command object that creates three result sets
ShowSQLADORecordsetCommandOpen Procedure Open an ADO recordset using the Open method using an ADO command object
ShowSQLADORecordsetCommandParametersMultipleRS Procedure Create a simple command object using the existing connection. Create explicit parameters and supply the values via the parameter object. Open the recordset from this command. Change the parameters and re-open the recordset
ShowSQLADORecordsetCommandSimpleParameters Procedure Create a simple command object using the existing connection. Create explicit parameters and supply the values via the parameter object. Open the recordset from this command
ShowSQLADORecordsetConnectFromStringTableName Procedure Open an ADO recordset using a connect string argument to create an implicit connection, using a table name as the record source
ShowSQLADORecordsetConnectFromStringView Procedure Open an ADO recordset using a connect string argument to create an implicit connection, using a view as the record source
ShowSQLADORecordsetConnectFromUDL Procedure Open an ADO recordset using a connection created from a "Universal Data Link" file -- UDL
ShowSQLADORecordsetConnectionExecute Procedure Open an ADO recordset with an existing connection using the execute method to create a read-only recordset
ShowSQLADORecordsetConnFromStringSelectStatement Procedure Open an ADO recordset using a connect string argument to create an implicit connection, using a SQL Select statement as the record source
ShowSQLADORecordsetDisconnected Procedure Create a disconnected recordset
ShowSQLADORecordsetFromCommandWithParameters Procedure Create a command object with two parameters using an existing ADO connection. Supply the parameters as arguments to the execute method to create a read-only recordset
ShowSQLADORecordsetFromConnection Procedure Open an ADO recordset using a connection created from a separate ADO Connection object
ShowSQLADORecordsetSPFromCommandExplicitParams Procedure Open an ADO recordset from the results of a SQL Server stored procedure returned from an ADO command object Parameters assigned explicitly
ShowSQLADORecordsetSPInputAndOutputParams Procedure Create a command object based on a stored procedure. Supply input parameters by creating parameter objects. Retrieve the output parameter into a parameter object. Get procedure return values into a parameter object. Execute the command, and open the recordset from this command.
ShowSQLADORecordsetStoredProc Procedure Open an ADO recordset from the results of a SQL Server stored procedure
ShowSQLADORecordsetStoredProcCommandReturnParams Procedure Open an ADO recordset from the results of a SQL Server stored procedure returned from an ADO command object Parameters assigned explicitly, and results returned from output parameter
ShowSQLADORecordsetStoredProcFromCommand Procedure Open an ADO recordset from the results of a SQL Server stored procedure returned from an ADO command object
ShowSQLADORecordsetStoredProcFromCommandWithParams Procedure Open an ADO recordset from the results of a SQL Server stored procedure returned from an ADO command object, supplying parameter values
ShowSQLADORecordsetStoredProcUsingStringParams Procedure Open an ADO recordset from the results of a SQL Server stored procedure called by creating the parameters as string arguments
SQLADORecordsetCommandOrdinalParameters Procedure Create a simple command object using the existing connection. Supply input parameters by using ordinal values. Open the recordset from this command

Overview of Total Visual SourceBook

The source code in Total Visual SourceBook includes modules and classes for Microsoft Access, Visual Basic 6 (VB6), and Visual Basic for Applications (VBA) developers. Easily add this professionally written, tested, and documented royalty-free code into your applications to simplify your application development efforts.

Additional Resources
Feedback

Contact Us  l   Web questions: Webmaster   l   Copyright © FMS, Inc., Vienna, Virginia
Celebrating our 26th Year of Software Excellence