DataSet Iteration?

[Adam]

Hi All,

What is the most acceptable way of iterating through a DataSet Tables Row
Collections Manually?
As in:

'fill data adapter object with dataset info
Da = New SqlDataAdapter(Cmd)
Da.Fill(Ds)

'iterate through Area Grouops
Do While() ????

'create new drop down list item
lstItem = New ListItem()
lstItem.Text = " -" & rdrAssessmentAreas("name")
lstItem.Value = rdrAssessmentAreas("assmnt_area_id")

'add new list item to drop down list
ddlAssessmentAreas.Items.Add(lstItem)

Loop

Cheers,
Adam

 

[Steve C. Orr [MVP, MCSD]]

I'd suggest something along these lines:

For Each row As DataRow in MyDataSet.Tables(0)
lstItem.Text = row("name").ToString()
Next

 

[Steve C. Orr [MVP, MCSD]]

I'd suggest something along these lines:

For Each row As DataRow in MyDataSet.Tables(0).Rows
lstItem.Text = row("name").ToString()
Next