easy question (FOR EACH)

[Brad]

I want to iterate through a dataset. What is the best way to do this? Can
I do something like:

for each datarow in ds
do stuff

Or is there a better way?

Thanks for the information.

Brad

 

[Cor Ligthert]

Brad,

for each datarow in ds
do stuff

almost right
for each dr as datarow in ds.tables(0).rows
do stuff with dr

I hope this helps?

Cor

 

[Brad]

Sure did help. Thanks Cor

Brad,

almost right
for each dr as datarow in ds.tables(0).rows
do stuff with dr

I hope this helps?

Cor

 

[adamz5]

Try something like this

'replace table with your table and tablename with your tablename
'replace yourdataset with your dataset

dim temprow As DataRow

For Each temprow In table.Rows
YourDataset.Tables.tablename.ImportRow(temprow)
Next