How to create connection string dynamically in C#

Question

How to create connection string dynamically in C#, instead of creating it using string concatenation?

Solution

You can create dynamic connection string with SqlConnectionStringBuilder Class in C# as follows.

for more details pls check http://msdn.microsoft.com/en-us/library/dce36088.aspx

private void Form1_Load(object sender, EventArgs e)
{
     SqlConnectionStringBuilder connectionString = new SqlConnectionStringBuilder();
     connectionString.DataSource = @".\SQLEXPRESS";
     connectionString.InitialCatalog = "MyDatabase";
     connectionString.IntegratedSecurity = true;
     MessageBox.Show(connectionString.ConnectionString);
}