Export data from access

tripes

Member
Joined
Apr 16, 2009
Messages
18
Programming Experience
Beginner
hi i am using VB.NET 2003 and i want to export some data from a microsoft access database into a multidimensional array... how can i do that? i could not find a single example on this...pls help :(
 
I would suggest that that's a very bad idea. Multi-dimensional arrays have their place but the number of situations where their use is appropriate is very small. Data from a database is far better left in a DataTable or else in a 1-dimensional array or collection of objects that have a property for each column.

That said, if you really do want to use a 2D array then you should populate a DataTable first, then use nested For loops to visit every column of every row and transfer the data from the DataTable to the corresponding position in the array.
 

Latest posts

Back
Top