by Ewart MacLucas (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: 
(7 Votes)
Provides a wrapper around ADO future proofing your code and making accessing your database much easier. Ensures all your code is standard and uses the best data base access techniques. Also provides functions to convert a recordset to HTML or CSV format - handy for web pages as well as client/server applications. WOULD love your feedback, feel free to contact me directly or submit comments.
Inputs
Can take connection string to database, query, stored procedure names and input/output recordsets.
Assumes
As reccomended by microsoft, you should be developing component based solutions for your database applications.. this code is best used if you are serious about writing database apps.
Code Returns
Recordsets, Array or Strings (HTML, CSV) representations of your data
Download Data Access Wrapper (11 KB)
VBcoders