Hello,
In your app.config, you can define several connection strings :
<configuration>
<connectionstrings>
<add name="cs_local">
connectionString="Data Source=(local);Initial Catalog=YourDB;Integrated Security=True"/>
<add name="cs_remote">
connectionString="Data Source=YourServer;Initial Catalog=YourDB;Integrated Security=True"/>
</add></add></connectionstrings>
</configuration>
And then, in your code-behind, you can do that :
string cs_name = string.Empty;
if (your condition)
cs_name = "cs_local";
else
cs_name = "cs_remote";
var connectionString = ConfigurationManager.ConnectionStrings[cs_name].ConnectionString;
Don't forget to add System.Configuration in your Using Directives ;)