I have an ASP.NET Web site.
I have a "MyCS" connection string in my web.config.
I have a "MyDS" dataset in my App_Code.
In MyDS I have created several table adapters using MyCS.
Now in real life I have multiple databases, all equal in design (same tables and relationships) but with different data (each belonging to a different customer).
Alll customers use the same web, but each must connect to their own database. So after an user logins I retrieve a profile value containing the name of the database he is supposed to connect to. But...
How do I change MyCS dynamically so that each user connects to his/her own database?
Thanks in advance.