All pastes #219775 Raw Edit

Shin-Ra

public text v1 · immutable
#219775 ·published 2006-10-24 21:16 UTC
rendered paste body
        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;
        }