i am willing to use either and realize that a DataReader is forward-only; however, I'd like to place each row from a query into an array after running the query and getting a DataReader/DataSet. This is from an Access database. Any ideas?

What are you trying to do with the data?

I want to put each value into an array, and then pull the integer value from one field out in each row and add it to the next (i.e., I want to create a total for that field based on the rows pulled) Like so:

Table Invoices

Transaction Date OrderID Client ID Transaction Price
1234 9/9/2004 1 2 148
4567 9/10/2004 2 2 129
7890 9/12/2004 3 2 118


I want the total, 395, returned to me.

for a row count you need to count rows on a table in the dataset

dim intRC AS Integer
intRC = ds<Name>.Tables(0).Rows.Count