title: Choice Between Connection DataSource C#
body: <p>I've got a dataAdapter, dataSet and BindingSource on my forms to connect to an SQL database to show the data in the form, and it all works fine. However, I need to have 2 options of what server to connect to.
  e.g ISSP\SQLEXPRESS and MY-WEB.
  I don't know how to do this and wondered whether anyone could give me some help on where to start? Thanks :)
  But when using the variables it says that it can't connect.</p>
  
  <p>I'm using the code below but it says that it can't connect, so i'm wondering whether i'm refering to the variable wrong?</p>
  
  <pre><code>sqlConnectionNW.ConnectionString = "Data Source=@server;Initial Catalog=Northwind;Integrated Security=True";
  </code></pre>
  
  <p>When I change the code to the following, it works perfectly.</p>
  
  <pre><code>sqlConnectionNW.ConnectionString = "Data Source=ISSP\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True";
  </code></pre>