Looping through a dataset table

[mike55]

Hi

Have a dataset with a table in it. Need to loop through this table and select the value of cell(1) from the table.

Have tried the following

For Each selIndex In dsDataset.Tables(page).Columns(0)

Next

The error I am getting is:Expression is of type System.Data.DataColumn, which is not a collection type.

Mike55.

 

[neodatatype]

Hi

Have a dataset with a table in it. Need to loop through this table and select the value of cell(1) from the table.

Have tried the following

For Each selIndex In dsDataset.Tables(page).Columns(0)

Next

Try this:

For Each dr As DataRow In dsDataset.Tables(page).Rows
    Debug.Print dr.Item(0).ToString()
Next

 

[mike55]

Yea,

That code works, many thanks.

Mike55