Occasionally there’s a need to construct a new connection string from user input instead of using a predefined one from the Web.Config file. Using the SqlConnectionStringBuilder class, a new connection string can be constructed easily without resorting to string concatenations.
private string BuildConnectionString()
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = txtServerName.Text;
builder.InitialCatalog = ddlDatabase.SelectedValue;
builder.UserID = txtUserId.Text;
builder.Password = txtPassword.Attributes["value"];
builder.ConnectTimeout = 60;
return builder.ConnectionString;
}
