By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

VB.Net and database

P: n/a

--
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.
Nov 21 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
"=?Utf-8?B?am9obiBhbmRyZXc=?=" <jo********@discussions.microsoft.com>
wrote in news:F7**********************************@microsof t.com:
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.


It's not harder than ADO - it's only "harder" because you're not used to
ADO.NET.
--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 21 '05 #2

P: n/a
> 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
Nov 21 '05 #3

P: n/a
Hi
I can do a a lot of stuff in VB.net already, it wasnt that difficult. Some
harder may be but thats programming for you.
I can do some Java and OOP in VB6. I cant see how VB.net is so difficult to
understand when having a C,Java,OOP background to an Intermediate level.

The database stuff I was confused with as it didnt appear to be smarter.
"Jim Edgar" wrote:
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

Nov 21 '05 #4

P: n/a
"john andrew" <jo********@discussions.microsoft.com> schrieb:
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.


The code will be the same in VB.NET Standard and Professional. The
Professional edition includes designers that will automatically generate
code for you and thus will help you to save time. In addition to that,
VS.NET's server explorer supports more server/database types than in the
Standard edition.

There are many substantial differences between data access in VB6 and
VB.NET. Currently, I assume you are used to the way to do data access in
VB6, so it seems to be harder for you to do that in VB.NET. Once you have
understood how data access works with .NET, it would be as easy as in VB6
for you.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>
Nov 21 '05 #5

P: n/a
Can you program a access database (link and manipulate like in VB6)in VB.net
with code in Standard edition?

"Herfried K. Wagner [MVP]" wrote:
"john andrew" <jo********@discussions.microsoft.com> schrieb:
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.


The code will be the same in VB.NET Standard and Professional. The
Professional edition includes designers that will automatically generate
code for you and thus will help you to save time. In addition to that,
VS.NET's server explorer supports more server/database types than in the
Standard edition.

There are many substantial differences between data access in VB6 and
VB.NET. Currently, I assume you are used to the way to do data access in
VB6, so it seems to be harder for you to do that in VB.NET. Once you have
understood how data access works with .NET, it would be as easy as in VB6
for you.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

Nov 21 '05 #6

P: n/a
John,

You can try this sample that I once made and is in this message,

http://groups-beta.google.com/group/...00033570443de4

You can just paste it in almost every class.

Because you cannot create in dotnet an Access database is that done in using
ADODB (ADOX).
A reference you set by doing Project -> add References -> Com and select
that needed dll.

When the access database is created it makes some tables in that database
using ADONET.

Than those tables are still not populated. However when you go than on and
look on MSDN for
Dataset
Datatable
Datarow
Dataview
OledbDataadapter
OledbCommandbuilder
Datagrid (to test)

You find enough samples to go on with that or just reply to this newsgroup,
than me or others will probably suply you other samples.

I hope this helps?

Cor


"john andrew" <jo********@discussions.microsoft.com> schreef in bericht
news:91**********************************@microsof t.com...
Can you program a access database (link and manipulate like in VB6)in
VB.net
with code in Standard edition?

"Herfried K. Wagner [MVP]" wrote:
"john andrew" <jo********@discussions.microsoft.com> schrieb:
> 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.


The code will be the same in VB.NET Standard and Professional. The
Professional edition includes designers that will automatically generate
code for you and thus will help you to save time. In addition to that,
VS.NET's server explorer supports more server/database types than in the
Standard edition.

There are many substantial differences between data access in VB6 and
VB.NET. Currently, I assume you are used to the way to do data access in
VB6, so it seems to be harder for you to do that in VB.NET. Once you
have
understood how data access works with .NET, it would be as easy as in VB6
for you.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

Nov 21 '05 #7

P: n/a
"john andrew" <jo********@discussions.microsoft.com> schrieb:
Can you program a access database (link and manipulate like in VB6)in
VB.net
with code in Standard edition?


Yes.

<URL:http://www.connectionstrings.com/>
-> "Access"

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>
Nov 21 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.