new SqlConnectionStringBuilder(conString) : SqlCommandBuilder « Database ADO.net « C# / C Sharp






new SqlConnectionStringBuilder(conString)

 

using System;
using System.Data.SqlClient;

class MainClass {
    public static void Main(string[] args) {
        string conString = @"Data Source=.\sqlexpress;" +
            "Database=Northwind;Integrated Security=SSPI;" +
            "Min Pool Size=5;Max Pool Size=15;Connection Reset=True;" +
            "Connection Lifetime=600;";

        SqlConnectionStringBuilder sb1 = new SqlConnectionStringBuilder(conString);

        Console.WriteLine("  " + sb1.ConnectionString);

    }
}

 








Related examples in the same category

1.InitialCatalog
2.IntegratedSecurity
3.MinPoolSize
4.MaxPoolSize
5.LoadBalanceTimeout
6.ConnectionReset
7.Generate SQL command automatically from SqlCommandBuilder and SqlDataAdapter