|
ADO Connection, Command, Recordset, and Parameter Object Example
| Version Compatibility: |
Visual Basic 5 Visual Basic 6
|
More information: This is a small example on how to extract the recordset by executing a stored procedure using command object of ADO. It demonstrates the major objects of ADO (connection, command, parameter, and recordset) and is therefore good for beginners to use as a starting point.
The example is based on a stored procedure in a SQL Server database. The procedure is as follows:
Procedure GetRecords
@rowC int output,
@statement varchar(50) output
As
select * from exe /*You can use any table which is present in the database*/
set @rowC=@@rowcount
set @statement='hey good work..buddy'
return
For more, information visit:
http://www.geocities.com/priyadarshu This code has been viewed 364706 times. Instructions: Copy the declarations and code below and paste directly into your VB project.
Declarations:
No Text Boxes
|
