Looping through a dataset (VB .net)

[tonyyeb]

Hi all

I have found some nice code that imports and Excel spreadsheet into a dataset that then fills a Datagrid.

I want to loop through the dataset and act on each rows data (like you would loop through a recordset in vbs/VB6).

Has anyone got any example code of how to do this? Or is there a better way to this... maybe update my skillset from the dark ages!

Cheers

 

[Stelly]

why dont you fo a foreach statement what runs while there is data in the spreadsheet cell?

Stelly

 

[tonyyeb]

why dont you fo a foreach statement what runs while there is data in the spreadsheet cell?

Stelly

Sorry you've lost me there. Can you explain in more detail please?

 

[tonyyeb]

I have found the solution:

Dim drCurrent As DataRow
        For Each drCurrent In objDataset1.Tables(0).Rows
            MsgBox(drCurrent.Item("FirstName"))
        Next

Where drCurrent.Item("FirstName") = the column header value or field name.

 

[Stelly]

sorry mate, busy day, but I see you worked it out with a foreach loop

Stelly

 

[tonyyeb]

sorry mate, busy day, but I see you worked it out with a foreach loop

Stelly

Aye got there in the end. It was the datarow that sealed it for me!

 

[Stelly]

good good

Stelly