Gary Dewrell
asked on
Teach and old Dog new Tricks (Old dumb dog at that)
I have a program that I wrote in vb5 several years ago. It usess an access 97 db and several instances of the datacontrol with bound controlls like datagrids and others.
I would like to convert it to VB6 or even better VB 2005 express, do away with the datacontrols, upgrade to possibly access 2003.
Easy points for the best referance for accomplishing this. Very detailed explanation with examples would be great, especially on doing away with the datacontrols.
Thanks!
I would like to convert it to VB6 or even better VB 2005 express, do away with the datacontrols, upgrade to possibly access 2003.
Easy points for the best referance for accomplishing this. Very detailed explanation with examples would be great, especially on doing away with the datacontrols.
Thanks!
You will need to use ADO to manually connect to your db if you don't want the data controls.
It's quite simple.....
Next about your code...your VB5 code should work nicely in VB6, as VB6 only offers enhancements to VB5, it still uses all the stuff we did in VB5 and just add's to it.
About the DB...Get Newes access, open your old DB, and convert it to the new access format.
This should get you started....
Maybe you could post some more deatiled questions?
It's quite simple.....
Next about your code...your VB5 code should work nicely in VB6, as VB6 only offers enhancements to VB5, it still uses all the stuff we did in VB5 and just add's to it.
About the DB...Get Newes access, open your old DB, and convert it to the new access format.
This should get you started....
Maybe you could post some more deatiled questions?
just curious ... what is "VB 2005 express"
Hmmmm....Looks like it's the new VB.NET (Maybe Whidby) "Light Edition"
http://lab.msdn.microsoft.com/express/vbasic/default.aspx
http://lab.msdn.microsoft.com/express/vbasic/default.aspx
ASKER
That is correct x50! It is a lite version of vb.net. They also have a sql express, c# express, etc. It is mainly for those who just want to do winforms.
Back to my issue. Could some one take a moment to explain how to use ADO.
I have several forms accessing several tables from my database.
Im just looking for sorta guide to get started.
Some forms are accessin several tables at the same time. So a quick explanation (not real detailed, I want to figure that out myself, but I need a push) of how to use ado to connect to the database, execute querys that update records, retrieve data for use in datagrids, etc..
One specific question I have is do I have to write the same code over and over again on each form?
Back to my issue. Could some one take a moment to explain how to use ADO.
I have several forms accessing several tables from my database.
Im just looking for sorta guide to get started.
Some forms are accessin several tables at the same time. So a quick explanation (not real detailed, I want to figure that out myself, but I need a push) of how to use ado to connect to the database, execute querys that update records, retrieve data for use in datagrids, etc..
One specific question I have is do I have to write the same code over and over again on each form?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oh yes and you have to set the propper references in your project....look for Microsoft ActiveX Data Objects and add it as a reference.
Cheers
Fade
Cheers
Fade
A thorough explanation on why to take the leap (ADO to ADO.NET) and how to go about it:
Migrating Code and Concepts from ADO "Classic" to ADO.NET
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnadonet/html/adocnet4.asp
Best regards,
Esopo
Migrating Code and Concepts from ADO "Classic" to ADO.NET
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnadonet/html/adocnet4.asp
Best regards,
Esopo
ASKER
Thanks guys, I will look trough all of these within the next 24-28 hours and award appoints.
Take a look at these links:
https://www.experts-exchange.com/questions/21045568/Migrating-from-VBA-to-VB-net.html
https://www.experts-exchange.com/questions/20840964/rebuilding-my-MS-Access-aplication-with-VB-Net.html
Best regards,
Esopo.