public DataTable ExecuteSelectCommand(SqlCommand comm) { QueryCounter qc = new QueryCounter(comm.CommandText); DataTable table; try { comm.Connection.Open(); SqlDataReader dr = comm.ExecuteReader(); table = new DataTable(); table.Load(dr); dr.Close(); } catch (SqlException ex) { throw ex; } finally { comm.Connection.Close(); qc.Dispose(); } return table; }