Build a connection string from component parameters and display it : SqlConnectionStringBuilder : ADO.Net C# Examples

    
using  System;
using  System.Data.SqlClient;

class  MainClass
{
        public  static  void  Main(string[]  args)
        {
                
                SqlConnectionStringBuilder  sb2  =  new  SqlConnectionStringBuilder();

                sb2.DataSource  =  @".\sqlexpress";
                sb2.InitialCatalog  =  "Northwind";
                sb2.IntegratedSecurity  =  true;
                sb2.MinPoolSize  =  5;
                sb2.MinPoolSize  =  15;
                sb2.LoadBalanceTimeout  =  600;
                sb2.ConnectionReset  =  true;

                Console.WriteLine("Constructed  connection  string:");
                Console.WriteLine("    "  +  sb2.ConnectionString);
        }
}