Loop through columns of all datarows in a dataset

[Philip Wagenaar]

I have a dataset that I queried from an excel sheet. I want to loop through
the rows, then loop through the columns and write them to a file. But I got
stuck pretty quickly:

So far:

For Each dr As DataRow In Order.Tables(0) .Rows

Next

In this for each I want to start a second for each for the columns. But it
seems that a datarow does not have a columns collection I can loop through?

How can I loop through the colomns in each datarow?

[Cor Ligthert [MVP]]

Philip,

The datacolumn describe the items from the rows.

For Each dr As DataRow In Order.Tables(0) .Rows
For each it as object in dr.ItemArray
'
next
Next

I hope this helps,

Cor

"Philip Wagenaar" <ph************ *@online.nospam > schreef in bericht
news:95******** *************** ***********@mic rosoft.com...

I have a dataset that I queried from an excel sheet. I want to loop through
the rows, then loop through the columns and write them to a file. But I
got
stuck pretty quickly:

So far:

For Each dr As DataRow In Order.Tables(0) .Rows

Next

In this for each I want to start a second for each for the columns. But it
seems that a datarow does not have a columns collection I can loop
through?

How can I loop through the colomns in each datarow?

[Armin Zingler]

"Philip Wagenaar" <ph************ *@online.nospam > schrieb

I have a dataset that I queried from an excel sheet. I want to loop
through the rows, then loop through the columns and write them to a
file. But I got stuck pretty quickly:

So far:

For Each dr As DataRow In Order.Tables(0) .Rows

Next

In this for each I want to start a second for each for the columns.
But it seems that a datarow does not have a columns collection I can
loop through?

How can I loop through the colomns in each datarow?

You mean the column values?

for each value as object in dr.itemarray
- or -

for each col as DataColumn in Order.tables(0) .columns
dim value as object
value = dr(col)
next col
Armin