Database Applications 1

[deva1]

Hi All,
What is the best way to write Database application using VB 6.0. Using wizard(application and Data form) to create the skelton and modify that or start from the scratch.

Sorry, if it is stupid question? I am learning VB myself and I am beginner.So I am trying to get some advise from Gurus.

Thanks in advance

Dev

 

[dvannoy]

Using the Data Wizzard I think you dont have as much control over your application then if you wrote in code all your connection strings and recordsets. when I first started with VB I was trying to use the Wizzard as well and ran across limitations on what I can make work. It's alot more code to write but once you get going you'll never want to use the wizzard at all. There are lots of examples on connection strings and recordsets in this forum.

Good Luck

 

[zemp]

It will be slower to start but I think that you should skip the wizard and "start from scratch". There will be a steeper learning curve but you will be glad you stuck it out in the long run.

Take the time to learn ADO. It is a great tool to access the data and works with almost any database. Some tools such as DAO (also a good tool) are limited to specific databases.

Find tutorials on the net to get you started. Check out the following links.

http://www.freeskills.com

http://www.w3schools.com

http://www.tutorialfind.com/tutorials/programming/

http://www.juicystudio.com/tutorial/vb/index.html

http://www.1perlstreet.com/vb/scripts/ShowCode.asp?txtCodeId=12050&lngWId=1

http://www.galahtech.com/forums/showthread.php?s=&threadid=1675

Thanks and Good Luck!

zemp