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

[The_Grudge]

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

My purpose for looping through the datareader was so that I could check the fields in each record and modify them as needed (e.g. date formats, length). Are you suggesting I loop through the datatable instead?

I tried your code - it says "fill is not a member of 'System.Data.DataTable".

At this point I feel like I should mention I'm relatively new to VB.NET

I appreciate your help.