Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

BuildConnectionString solution

using System; using System.Data.SqlClient;     class Program     {         static void Main(string[] args)         {             SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder(  );             csb.DataSource = "(local)";             csb.Add("Initial Catalog", "AdventureWorks");             csb["Integrated Security"] = true;             Console.WriteLine("Connection string:\n{0}", csb.ConnectionString);             SqlConnection connection = new SqlConnection(csb.ConnectionString);             connection.Open(  );             Console.WriteLine("\nConnectionState = {0}", connection.State);             connection.Close(  );             Console.WriteLine("ConnectionState = {0}", connection.State);         }     }