How to store database records into array with VB.NET?

I want to retrieve all records from an MS Access table and store them into an array. Can someone give me an example of how to do that in VB.NET? Thanks in advance!

Oops, ignore

I'm interested in doing this same thing, and I'm wondering if anyone found a solution to this question. I want to execute a procedure in SQL Server 2000 in my VB.NET program, and then be able to somehow read the return, line-by-line. Is this even possible?

What makes this situation even a little more difficult is that I'm hoping I can do this from a console app, so it's not like I can just create a datagrid control, populate it using the DataAdapter, and then just read the values back out of the datagrid. I'll need to be able to do all the data reading programatically and "behind the scenes", since I won't have any GUI controls to work with. Thanks for your help!

Here is an example of how to extract data from a single cell in a database. You would need to set up an adapter, a connection, and a data set in order to use this command. You can either set it up through the server explorer or by code. This command assumes the data set is DataSet1, Contacts is the name of the table, and X,Y are coordinates.


DataSet1.Tables("Contacts").Rows(Y).Item(X)