Please support our VB.NET advertiser: Programming Forums
Views: 17022 | Replies: 5
![]() |
•
•
Join Date: Feb 2005
Location: Braintree, UK
Posts: 1,166
Reputation:
Rep Power: 7
Solved Threads: 59
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:
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.
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 classI'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.
Last edited by hollystyles : Jul 27th, 2006 at 5:34 am.
•
•
Join Date: Aug 2004
Posts: 19
Reputation:
Rep Power: 5
Solved Threads: 0
Hi,
You can develop a module of ERP which is currently hot in the IT market. This will help you to appear for ERP related job interviews. Develop a module like Accounting/ Inventory using vb.net and SQL server 2000/2005 with a focus on database connections using ADO.net, OOPs Programming, multi-tier architercture and reporting.
For your information, the Title:"Develop an accounting package using Visual basic and SQL sever 2000 (Client/Server) can give you a headstart.
Regards
bhar
You can develop a module of ERP which is currently hot in the IT market. This will help you to appear for ERP related job interviews. Develop a module like Accounting/ Inventory using vb.net and SQL server 2000/2005 with a focus on database connections using ADO.net, OOPs Programming, multi-tier architercture and reporting.
For your information, the Title:"Develop an accounting package using Visual basic and SQL sever 2000 (Client/Server) can give you a headstart.
Regards
bhar
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)






Linear Mode