public void DisposeConnection() { if (Connection.State == ConnectionState.Open) Connection.Close(); Connection.Dispose(); }