using System;

using System.Data.SqlClient;

public class Program

{

    public static void Main()

    {

              // Using the SqlConnectionStringBuilder

            var sqlconnectstring = new SqlConnectionStringBuilder();

            sqlconnectstring.IntegratedSecurity = true;

            sqlconnectstring.InitialCatalog = "students";

            sqlconnectstring.DataSource = "localhost";

            //sqlconnectstring.UserID = "hillary";

            //sqlconnectstring.Password = "hillary";

​

            string connectionString = sqlconnectstring.ToString();

​

            using (SqlConnection cnn = new SqlConnection(connectionString)) {

                try

                {

                    cnn.Open();

                    Console.WriteLine("Connection Open ! ");

                    cnn.Close();

                }

                catch (Exception ex)

                {

                    Console.WriteLine("Can not open connection ! "); 

                }

​

            }

​

            }

    }

​