Author:	Brian Gillham (Featured Developer)
Category:	Database
Type:	Classes
Difficulty:	Intermediate

Version Compatibility:

Visual Basic 6

More information: This class encapsulates many routine tasks in ADO programming, which reduces the tedium and increases the reusability of your code. For example, if you pass it a valid connection string, it will automatically set up a connection, if you pass it a valid SQL string, it will return a recordset, and so on. It includes a function that returns a shaped (parent-child) recordset, without you having to deal with writing the complex SQL that is required for shaped recordsets.

Version 2.0, added 06/06/02, incorporates the SMARTSql class on this site and also adds improvements such as automatic selection of cursors. There is a sample project; you may have to modify the connection string that is included as a constant to get it the sample to work.

This code has been viewed 178105 times.

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

source/ADOUtils.zip