vb.net and ado [RESOLVED]

[Andy]

can you still use ado when you program in vb.net? I'm sure there is no problem.

[mendhak]

Use ADO.NET.

[Andy]

thats what I'm running up against. my project leader want to use ado and no ado.net. Now I've got to learn no only vb.net but ado AND how to use the two together!! what a life

[sw_is_great]

u can use ADODB

[sw_is_great]

Set myConnection = New ADODB.Connection
Set myRecordset = New ADODB.Recordset

myConnection.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=abc.mdb"

myConnection.Open


myRecordset.Open "Select * from tablename ", myConnection

bla
bla
bla

[sw_is_great]

mendhak

ADO.NET is a replacement for ADO.

As far as I know ADO.NET is for non connected mode and if ur project is like the one of airlines or train reservation, u cannot use ADO.NET

[Andy]

Originally posted by sw_is_great
Set myConnection = New ADODB.Connection
Set myRecordset = New ADODB.Recordset

myConnection.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=abc.mdb"

myConnection.Open


myRecordset.Open "Select * from tablename ", myConnection

bla
bla
bla

when I enter this in my program, (I have to use 'dim' instead of 'set' or i get a syntax error) I get the familiar squigly blue underlines and it says that the adodb.connection is not defined. same with the recordset. is there a namespace I need to import?

[Andy]

aha! discovered that I need to goto 'Project' and then add a reference to adodb!! learning...learning!!

[Mike Collier]

Many of the ADODB (ADO) properties are displayed in adoanywhere free tool. Helps you learn faster.