what is meant by ADODB.connection?

[williamku87]

i find a sample code ADODB.connection...
i do a little modify but when i declare Dim CN As New ADODB.Connection
the ADODB.connection is underline,...
what the problem?

 

[MattP]

Imports System.Data.Oledb

Is this line at the top of your code?

 

[cjard]

I dont think we use ADODB.Connection any more.. that's VB6

 

[Saket]

Well in Vb.Net the connection object will depend on the type of database that u are trying to connect to. If its a Sql database then u should first type:
imports.Data.SqlClient (Outside the class body).

and then inside the class u can use
dim CN as New SqlConnection

Similarlly for MsAccess Database, first u type:
Imports.Data.OLeDB

and then within the class u type:

dim CN as New OLeDBConnection


Try it out....

Hope it Helps

 

[Vishal Rana]

Read this:

ADODB Services in .NET Applications using VB.NET