Traverse all records in dataset (ado.net)

[drluggo]

I am new to ADO.NET and I am familiar with ADO. I can create a dataset in ADO.NET by connecting and creating a data adapter and filling my dataset.

Now that I have this data I want to trverse all records in the dataset unitl EOF. In ADO, I would have done this with a recordset like:

rs.MoveFirst
Do While (Not (rs.EOF))
.....
rs.MoveNext
Loop

How do I do this with a dataset in ADO.NET???

 

[chmohan]

for i=0 to ds.tables(0).Rows.Count -1
your code
next

depends on how many recordsets(tables) u bring back in ur dataset for multiple you would have to do another loop for each table in dataset