if (conn.State == ConnectionState.Open) { conn.Close(); } if (conn.State == ConnectionState.Closed) { conn.Open(); }