VBcoders Browse New Submit Contact Sign In

No account? Register free

Forgot password?

ClassGen .1

Lawrence Miller  (2 Submissions)   Complete Applications   Visual Basic 5.0   Advanced   Wed 3rd February 2021

This program will read a SQL Server database or MS Access database and write Classes and Collections for each table you select. It is a complete application with all source code included. I have commented some of the code but most is self documented.

Inputs
Database Type, ServerName, DatabaseName, User Login, Password

Assumes
What you can learn from this program. 1. How to use ADO - Connections, Recordsets, Update, Insert, Delete 2. How to use the ADOX Reference to get various information from a database (i.e. TableNames, TableTypes, FieldNames, FieldTypes, etc...) 3. Classes 4. Collections 5. Writing to a sequential file.

Returns
Classes and Collections

Side Effects
If you have extremely large tables you may have to do some editting to the generated code as it uses line concatenation. If there are too many continued lines, VB won't load the module.

API Declarations
ReadPrivateProfileString
WritePrivateProfileString

Rate ClassGen .1 (13(13 Vote))

Download ClassGen .1

ClassGen .1 Comments

No comments yet — be the first to post one!

Post a Comment

0/1000 characters