Using VB and ADO.NET

20 Oct 2006 4:34 PM

Shooter4Life8

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 OleDbDataAdapter 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 OleDbDataAdapter 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)

20 Oct 2006 4:44 PM

Cor Ligthert [MVP]

www.connectionstrings.com is your first friend.

Cor

<Shooter4Li***@gmail.com> schreef in bericht
Show quoteHide quote

news:1161362055.225768.47120@i3g2000cwc.googlegroups.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 OleDbDataAdapter 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 OleDbDataAdapter 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)
>

20 Oct 2006 4:45 PM

rowe_newsgroups

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:

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

Shooter4Li***@gmail.com wrote:
Show quoteHide quote

> 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 OleDbDataAdapter 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 OleDbDataAdapter 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)

20 Oct 2006 5:31 PM

Shooter4Life8

I think I got it fixed

Shooter4Li***@gmail.com wrote:
Show quoteHide quote

> 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 OleDbDataAdapter 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 OleDbDataAdapter 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)