A class generator.
INPUT connection string and table name.
OUTPUT a .vb class file with members, insert/update/delete methods for the given table
so if you had in the db
address
line1 varchar(32)
line2 varchar(32)
your generator would produce:
class address
private line1 as string
private line2 as string
public InsertAddress()
Dim sql as string
sql = "insert into address(line1, line2) values('" & line1 & "','" & line2 & "')"
end sub
:
:
end class
I'm a c# programmer so you'll have to excuse my rubbish VB syntax but you get the idea I hope.
This will not only give you a project for your studies, but will have real use for you in the real world afterwards.
hollystyles
Veteran Poster
1,182 posts since Feb 2005
Reputation Points: 262
Solved Threads: 68