change SqlDataSource connection string in asp.net dynamically
<p>I have a page in asp.net (web forms) that up until now only had one database for data.</p>

<p>So all the controls that require something from the database use a datasource and the same connection string. </p>

<pre><code>&lt;asp:SqlDataSource id="SqlDataSource1" runat="server"
                    ConnectionString="&lt;%$ ConnectionStrings:DefaultConnectionString %&gt;" 
                    ProviderName="System.Data.SqlClient" 
                                        SelectCommand="SELECT ... "&gt;
&lt;/asp:SqlDataSource&gt;
</code></pre>

<p>Up until now I only needed one connection string since I had only one database but this has changed since I want some users to connect to database A and others to database B</p>

<p>What would be the correct way to go about it? Preferably without many changes...</p>
