ADO connection with VB.NET

[andrew]

I have just read the code to connect to an SQL database using ADO in VB.net. This looks way more complicated then VB6 and it is hard to see how this is better

In VB.net if I just wanted to connect to an Access database using ADO and do basic operations of navigate,add,up date,delete records is it really that complicated as compared to VB

Can you connect to an Access 97 database

thanks

[Cor Ligthert]

Re: ADO connection with VB.NET

Hi Andrew,

Why are you not using ADONET, ADO is so complicated to make connections?

If you are using VS2003, than you start with dragging from the toolbox the
OLEDB adapter, (A wissard starts) and you follow what you have to do. The
only thing I have to add in my opinion is that you have to choose in the
connection property box, the first tab, you choose in there the right Jet
provider and goes on, because the rest is in my opinion easy.

(This is only to learn in future you will probably do it in another way)

Cor

[andrew]

Re: ADO connection with VB.NET

I am getting confused with database connections with ADO.net. It seems you can connect to a database like access using the oledb connection and also using .net framework which is more complicated
Using .net data source you get the bonus of performance which is what VB.net wants people to move towards eventually

Just a simple databse like access then connecting through the jet engine (oledb)is the way. What a poorly explained topic databases are on VB.net, ?

[Cor Ligthert]

Re: ADO connection with VB.NET

Andrew,

Connecting in dotNet using OleDB = AdoNet.

For that you use a connection, however try what I said, it should be maximum
5 minutes to do.

There are also some checks in it and after the wizard.

When the Wizard is done you can do:
Generate datasset by right clicking on the Picture Oledbadatper which
appears below.
(There will as well be a connection picture)

I hope this helps..

Cor