Using VB and ADO.NET

[Shooter4Life8@gmail.com]

Hi, I am currently using Visual Basic from Microsoft Visual Studio 2003
..NET. I would like to create an ADO.NET connection to a local Access
database. Any pointers or helpful informational sites would be much
appreciated :)

My main questions are:

Do I need to add the OleDbDataAdapte r and OleDbConnection objects from
the data portion of the tool box? If so how do I get it to connect to a
local (on my local harddrive) access database? When I have tried, I
have right clicked the OleDbDataAdapte r and gone to configure data
adapter then I click New Connection. I'm not sure what to put in the
fields to get it to connect to the database.

If not, i've read about using some sort of connection string. (same
problem again. not sure what the connection string is for a local
database)

[Cor Ligthert [MVP]]

Re: Using VB and ADO.NET

www.connectionstrings.com is your first friend.

Cor

<Shooter4Life8@ gmail.comschree f in bericht
news:1161362055 .225768.47120@i 3g2000cwc.googl egroups.com...

Hi, I am currently using Visual Basic from Microsoft Visual Studio 2003
.NET. I would like to create an ADO.NET connection to a local Access
database. Any pointers or helpful informational sites would be much
appreciated :)
>
My main questions are:
>
Do I need to add the OleDbDataAdapte r and OleDbConnection objects from
the data portion of the tool box? If so how do I get it to connect to a
local (on my local harddrive) access database? When I have tried, I
have right clicked the OleDbDataAdapte r and gone to configure data
adapter then I click New Connection. I'm not sure what to put in the
fields to get it to connect to the database.
>
If not, i've read about using some sort of connection string. (same
problem again. not sure what the connection string is for a local
database)
>

[rowe_newsgroups]

Re: Using VB and ADO.NET

I don't use the datasource wizards, so I can't help you there. But if
you want to set up your connection through standard coding, then the
following link will walk you through it:

http://support.sas.com/ctx/samples/index.jsp?sid=817

And for the connection strings:

https://www.connectionstrings.com

Personally, I built a shared class that handles all my connections,
then if I need to change the methods for a project I just inherit that
class and override/overload any methods I need to change. Just my
opinion.

Thanks,

Seth Rowe


Shooter4Life8@g mail.com wrote:

Hi, I am currently using Visual Basic from Microsoft Visual Studio 2003
.NET. I would like to create an ADO.NET connection to a local Access
database. Any pointers or helpful informational sites would be much
appreciated :)
>
My main questions are:
>
Do I need to add the OleDbDataAdapte r and OleDbConnection objects from
the data portion of the tool box? If so how do I get it to connect to a
local (on my local harddrive) access database? When I have tried, I
have right clicked the OleDbDataAdapte r and gone to configure data
adapter then I click New Connection. I'm not sure what to put in the
fields to get it to connect to the database.
>
If not, i've read about using some sort of connection string. (same
problem again. not sure what the connection string is for a local
database)

[Shooter4Life8@gmail.com]

Re: Using VB and ADO.NET

I think I got it fixed

Shooter4Life8@g mail.com wrote:

Hi, I am currently using Visual Basic from Microsoft Visual Studio 2003
.NET. I would like to create an ADO.NET connection to a local Access
database. Any pointers or helpful informational sites would be much
appreciated :)
>
My main questions are:
>
Do I need to add the OleDbDataAdapte r and OleDbConnection objects from
the data portion of the tool box? If so how do I get it to connect to a
local (on my local harddrive) access database? When I have tried, I
have right clicked the OleDbDataAdapte r and gone to configure data
adapter then I click New Connection. I'm not sure what to put in the
fields to get it to connect to the database.
>
If not, i've read about using some sort of connection string. (same
problem again. not sure what the connection string is for a local
database)