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 153273 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
No comments:
Post a Comment