how to change connection string initial catalog

To change the connection string without modify it, you should do the following procedure:

1. Create a SqlConnectionStringBuilder object Assign your original connection string to it
2. Change the parameters that you want in the created SqlConnectionStringBuilder object.
3. Adding the SqlConnectionStringBuilder ConnectionString property to your DbConnection Object.

See the following example: (suppose that first you are created a normal DbConnection with your original conexion string (name db here)):

if (db != null){    SqlConnectionStringBuilder conn = new SqlConnectionStringBuilder(db.ConnectionString)   { ConnectTimeout = 5, InitialCatalog = "your CatalogName" }; // you can add other parameters.      db.ConnectionString = conn.ConnectionString;      db.Open();      return true;   }}

In the given example, the Initial Catalog and the timeout were changed without touch the original string.

I hope that this help you.

I think you will need a connection string for each database.

You have a drop down where the user selects which db to connect to. This value needs to be persisted, perhaps in the Session.

You need a class responsible for supplying a connection string value. This class gets passed the drop down value / pulls the value from the session, and returns the appropriate connection string to your DAL function

edit: if you have used the connection string name in all your pages you are going to have to change it. Encapsulate what might change. A search and replace might do it?