SqlConnectionStringBuilder

Using the new SqlConnectionStringBuilder class, you can build connection strings and then add them to your ConnectionStringSettings collection.
Listing shows how you can use the ConnectionStringBuilder class to dynamically assemble
connection strings at runtime and save them to your web.config file.


VB
’ Retrieve an existing connection string into a Connection String Builder
Dim builder As New System.Data.SqlClient.SqlConnectionStringBuilder()
’ Change the connection string properties
builder.DataSource = "localhost"
builder.InitialCatalog = "Northwind1"
builder.UserID = "sa"
builder.Password = "password"
builder.PersistSecurityInfo = true
’ Save the connection string back to the web.config
ConfigurationManager.ConnectionStrings("AppConnectionString1").ConnectionString = _
builder.ConnectionString
C#
// Retrieve an existing connection string into a Connection String Builder
System.Data.SqlClient.SqlConnectionStringBuilder builder = new
System.Data.SqlClient.SqlConnectionStringBuilder();
// Change the connection string properties
builder.DataSource = "localhost";
builder.InitialCatalog = "Northwind1";
builder.UserID = "sa";
builder.Password = "password";
builder.PersistSecurityInfo = true;
// Save the connection string back to the web.config
ConfigurationManager.ConnectionStrings["AppConnectionString1"].ConnectionString =
builder.ConnectionString;