Creating Connection String on-the-fly

It is possible for us to create and manage Connection String at run time by using SqlConnectionStringBuilder class, So we can change connectionstring at any time.

Example Code :

SqlConnectionStringBuilder ConnBuild = new SqlConnectionStringBuilder();

ConnBuild.DataSource = "SQLExpress";
ConnBuild.ConnectTimeout = 1000;

ConnBuild.IntegratedSecurity = true;
//or
ConnBuild.IntegratedSecurity = false;
ConnBuild.UserID = "Indrajeeth";
ConnBuild.Password = "Indrajeeth";

Response.Write(cnbuilder.ConnectionString); 

Some important properties of connectionstringbuilder class
InitialCatalog -
Used for returning or setting name of the database related with the connection.

IntegratedSecurity -
sets or returns false - indicating user-id and password is specified. and sets or returns false when current windows account credentials are used for authentication

UserID -
Used for returning or setting user ID while connecting to SQL Server.

Password -
Gets or sets the password for the SQL Server account.

ConnectTimeout -
Used for setting or returing the time span (in seconds) for waiting connection to the server before terminating.

DataSource -
Used for setting or returing the name or network address for connecting of the instance of SQL Server.

Encrypt -
Returns or sets Boolean value for specifing whether SQL Server uses SSL encryption for all data sent between the client and server (applicable only when the server has a certificate installed.)