How to Populate Arraylist from Access Database

[meduffy]

Hi everyone,

 

Does anyone know how to populate an arraylist using a query from an Access Database?

 

Once the arraylist is loaded, I will be doing an accumulative calculation for charting using vb.net.

 

Appreciate anyone's help.

Thanks

[Robby]

dr bieng your dataReader....

 

Dim arr As New ArrayList

While dr.Read()

arr.Add(Convert.ToInt32(dr("myIntColumn")))

End While