Listing 11-14: Building connection strings using ConnectionStringBuilder
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#
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;