User168863485 posted
I have a common connection string problem that I need some assistance with.
In my web application, I have multiple clients, each with their own database. I determine who the client is based on the URL. For example,
www.website.com/Client1 or
www.website.com/testclient. Once I determine the client, I need to set their connection string. I have multiple connect strings in a connection.config file that I reference in my web.config file.
How do I set all of my database connections to the proper connection string? I have seen some examples of session variables being used, but would like to avoid this. I have a strongly typed dataset that all point to the default connection string:
this
._connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnectionString"].ConnectionString;
Can I create a connection string in the global.asax, then change the above line to reference that connect string? Would that persist throughout the session, or do I have to add code to each user control to reference that connection string?
For example, can I do something like this?
ConnectionStringSettings
cs = ConfigurationManager.ConnectionStrings["ConnectionString"];
in global.asax
this._connection.ConnectionString = cs.ConnectionString; in dataset;
