multidimensional array and data table help

  • Thread starter Thread starter Steve Arndt
  • Start date Start date
S

Steve Arndt

In vb6, I used getrows to load data into a multi-dimensional array. Since
ADO.NET doesn't have getrows, I've succesfully loaded the same data into a
datatable.

How do I reference the data in the data table as a multi-dimensional array
for (row and column), or load the data into an array from the data table?
Or is there a better way to do this?

Thanks
 
Steve,

A datatable has two main collections
The datacolumns which describe the items
The itemcollection

To iterare you can use both

dim a as String = dt.rows(0)("Item1").ToString

Gives you the ("Item1") in the first row.
(Be aware that those enclosed strings are case sensitive in VB as well.

I hope this helps,

Cor
 
Can I use this in a loop. Basically what I was previously doing was looping
through an Array row by row setting cell structure in a Flexgrid for certain
cells based on a column number value in an array?
 
Got it to work...

Thanks

Steve Arndt said:
Can I use this in a loop. Basically what I was previously doing was looping
through an Array row by row setting cell structure in a Flexgrid for certain
cells based on a column number value in an array?

into
Click to expand...
 
Back
Top