Using a DataReader to populate a dataset

[techgnome]

use the data reader to fill the data table... thusly:

datatable.fill(yourDataReader)

now do what you need to do with the datatable. You don't need to loop through the reader yourself.

-tg