public Transaction() { try { myFunc.GetConnection(); ConnectionString = GlobalVar.mDataConnection; //sql = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); sql = new SqlConnection(ConnectionString); //sql.ConnectionString.Equals(ConnectionString); sql.Open(); } catch (Exception ex) { if (sql.State != ConnectionState.Closed) { sql.Close(); sql.Open(); } } }