OK, I'm sure this is simple, but I'm only just beginning to play with ADO.NET.

How do I create (and use) a single database connection to use with all Adapters in my project? It's going to be really awkward to do search and replace across all the connections I've defined when it is time to a new database.

Cheers,

Chris

There are two secrets to success in this world:
1. Never tell everything you know

__________________
There are two secrets to success in this world:
1. Never tell everything you know

You'll want to store the connection *string* in the application configuration file (either app.config or web.config). Your code will get the connection string from this file thru the ConfigurationSettings class. Then you can change the connection string in a single place without having to recompile any code.

-Peter

Cheers Peter,

It was a simple as I'd hoped :)

Chris

There are two secrets to success in this world:
1. Never tell everything you know

you write the code in web.config.
<appSettings>
<add key="ConnectionString" value="server = .;uid=sa;pwd=;database=abc"/>
</appSettings>

akd

Create the connection in the webconfig file

can any one give an example after create in .config how to use it. :P
i'm sorry coz a'm very new in ado.net

To retrieve the connection string from the appSettings element with a key named "ConnectionString" in you web.config file use:

C#

string connectionString = ConfigurationSettings.AppSettings["ConnectionString"];

VB.NET

Dim strConnectionString As String = ConfigurationSettings.AppSettings.Get("ConnectionS tring")

Then just use the connection string variable as you normally would with ADO.NET objects:

OleDbConnection cn = new OleDbConnection(connectString);

The ConfigurationSettings class is in the System.Configuration namespace so be sure you have the proper using or Imports directive.

HTH,

Bob