How do I change an XSD connection string dynamically?

Hello,

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.
richardhaegerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jinalCommented:
AS i understand you want to use diffrent connection string.

Either store all connection string for each of customer in web.config.

Or Create one database that is common to all customer and this database contain all information about customer . In that information keep database connection string.

So runtime retrieve that connection string and use in xsd connection string.
0
richardhaegerAuthor Commented:
Thanks for answering jinal but I can't do that.

As I said, in my dataset I have several table adapters I made with the table adapter wizard. The table adapter wizard asks for a connection string as the first step in the wizard. If I check the XSD code, I can see the wizard generated all the code for my table adapters using "MyCS" as connection string. If I define several connection strings, and change the connection string dynamically as you suggest, my XSD still pulls all the info from the connection string that it was created with. So what I need to do is change that CS dynamically, not change to another connection string.

I found this (exactly my problem):

http://stackoverflow.com/questions/435444/changing-xsd-connectionstring-at-runtime-for-a-multitenant-app

I'll try it tomorrow.
0
richardhaegerAuthor Commented:
I also found this:

http://www.asp.net/learn/data-access/tutorial-72-vb.aspx

I believe my solution is here.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
richardhaegerAuthor Commented:
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.