title: Dynamically sql connection
body: <p>hi 
  i`m using visual basic express 2010 and SQL server 2008 R2 
  this is my problem
  i create database in sql, then i connect to database by visual basic.
  like</p>
  
  <p><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
  &lt;configuration&gt;
    &lt;configSections&gt;&lt;/configSections&gt;
    &lt;connectionStrings&gt;
      &lt;add name="WindowsApplication1.My.MySettings.BPdataConnectionString"
        connectionString="Data Source=.\SQLBAC;AttachDbFilename=G:\SQLSERVER\MSSQL10_50.SQLBAC\MSSQL\DATA\BPdata.mdf;Persist Security Info=True;User ID=sa;Password=martin;Connect Timeout=30;User Instance=False"
        providerName="System.Data.SqlClient" /&gt;
      &lt;add name="BPdataEntities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;Data Source=.\SQLBAC;AttachDbFilename=G:\SQLSERVER\MSSQL10_50.SQLBAC\MSSQL\DATA\BPdata.mdf;Persist Security Info=True;User ID=sa;Password=martin;Connect Timeout=30;User Instance=False;MultipleActiveResultSets=True&amp;quot;"
        providerName="System.Data.EntityClient" /&gt;</code>
  
    
    
      
      </p>
  
  <p>everything is working but if i will use it in other PC then database directory and SQL server name will be different... 
  so i need to ask program before start for server name, database name...</p>