What is the best way to dynamic load connection strings
<p>I've seen some other posts in this topic, but thought I would ask the qustion with a description on my problem.</p>

<p>I have a login page wich uses SQL provider for the user login. Then the user should be redirected to the main application. This is a web based CRM application wich we have muliple clients.</p>

<p>My goal is to use a single web site, but multiple SQL databases. And the user that signes in should use a connection string that coresponds to the company he belongs.</p>

<p>Any good ideas?</p>
