ADO programming

[David]

Could someone please point me to a good book or web site tutorial for
programming databases in VB.NET 2003 using ADO ?

My application is running fine but when I deploy it to another machine, the
program cannot find the database file itself (I am using OledB to connect to
ACCESS database on local machine).

The Connection,dataadaptor and datasets were created using the wizards. When
I go into the MS written code and edit the connect string to include
"application.startup", I seem to loose connection to the data adapter.

Is there not some simple way setting up the program using the wizards and
informing the program to keep the path to the db file RELATIVE to what it is
now ??

Thanks in advance

David

 

[Ron Allen]

David,
A good ADO.NET book is
"ADO.NET Core Reference" by David Sceppa.
It isn't just a reference and has numereous examples and explanations for
both Sql and OleDb datasources.
I haven't had your problem as I don't use the wizards to construct
things but do this all in code. I keep program settings in an XML file in
IsolatedStorage for each user and supply a 'default' xml file for initial
startup. At this time the user selects the actual database and when the
program exits that is set as the default location for subsequent executions.

Ron Allen

 

[Cor Ligthert]

Hi David,

In addition to the advice from Ron, I have strugled long with this, so
therefore I was suprised that it was this easy .

When you set just the right connectionstring from your connection in the
Load Event of the form (or whatever place however before the open and after
that the connection is instanced). Than all works very nice.

Links to simple connection strings.
http://www.connectionstrings.com/

http://www.able-consulting.com/ADO_Conn.htm

And beside David Sceppa is even more William Vaughn a regular member of this
dotNet groups, so do not forget to look at his book.

And the next time you can better place adonet questions in the newsgroup

microsoft.public.dotnet.framework.adonet

the newsgroups where David and Bill are mostly active.

I hope this helps.

Cor