> hello
I was looking at database connection with VB.net and seeing what the
difference is between vb6/VB.net. In VB6 Prof, I can connect to an Access
databse using code with ADO. With relatively easlity to follow commands and
perform up/del/add on the database.
I have vb.net standard edition. I can connect to the Access database with
VB.net but the similarity stops there. The code I am using is harder to
follow and I cant do the same as VB6. Is that because I havent got VB.net
Professional or is VB.net just not as easy.
I have no interest in the SQL server database for argumnets sake and I want
to use code a databse just controls.
VB.Net is not VB6++. It's a new interface to the .Net framework that has some
similarities to VB6. It is not intuitive and must be learned in a structured way to
get it's full potential. I've programmed in VB for 14 years and I just completed
my first .net program which took *much* longer than I was expecting. My
project was a simple FTP project that downloads some files and re-formats
them. I wanted to convert the VB6 code that I had to .Net but it wasn't even
close (fixed length strings in a public structure, that took me two days to figure out
how to declare and use them with WinAPI calls).
If you are competent with VB6 then you should stay with it. VBScript and the
VB macro language built into Microsoft products are very similar and knowing
VB is a great advantage. When you decide to switch over to .Net you should
be ready to leave the old VB concepts behind and ready yourself to learn a
new language. I suggest a class at the local community college or some
commited time with some .Net books. Since you're learning a new language
you might as well look into C# to see if it's more to your liking. Either way,
the .Net languages are not hard to learn but you must commit yourself to
the task.
Some day I'll be forced into the .Net framework but learning a new language
at my age just doesn't seem appealing to me now. Good luck if you decide
to transition to .Net.
Jim Edgar