Database table to an Array

[jon159785]

I would like to pull data out of one table of database which has 5 rows and 2 columns into an array. I've set up the dataset and I know how to set up the loops, but what do you have to set up and what commands do you use to pull the data out? Thanks.

 

[jon159785]

Oh by the way..... the database is in Access

 

[nomi2000]

Hi Jon
here are differnt solution
a) You can use HASH TABLE
b) collection to store the data rows

I am assuming the you have set odataTable with rows from
database

Dim OdataTable As DataTable
Dim oRow As DataRow
Dim MyHash As New Hashtable()
Dim MyCol As New Collection()
For Each oRow In OdataTable.Rows
MyHash.Add("", oRow)
Next

'or
For Each oRow In OdataTable.Rows
MyCol.Add(oRow)
Next

Regards
Nouman

Nouman Zaheer
Software Engineer
MSR