Read Data Table Using Data Reader

How to read DataTable using DataReader? (DataTable is already filled).

Showing Answers 1 - 3 of 3 Answers

shamu_1984
Profile Answers by shamu_1984 Questions by shamu_1984

Oct 5th, 2009

Using CreateDataReader() Function, we can read the data

DataTableReader dtr = ds.Tables[0].CreateDataReader();

        while (dtr.Read())
        {

            for (int idx=0; idx < dtr.FieldCount;idx++ )
                Response.Write(dtr[idx]);

            Response.Write("<br/>");
        }