[2008] loop through database reocords

[jmcilhinney]

If you've already got the data in a DataTable then you simply loop through the rows it contains. For a typed DataTable, which you will have if you created a Data Source, then you can use the properties specific to your data, e.g.

For row As MyDataTableRow In myDataSet.MyDataTable
    MessageBox.Show(row.Name, row.ID.ToString())
Next row

If you have a standard DataTable, or if you prefer to do it this way with a typed DataTable, then you would use the standard members:

For row As DataRow In myDataSet.Tables("MyDataTable").Rows
    MessageBox.Show(CStr(row("Name")), row("ID").ToString())
Next row

You will obviously have to use different names appropriate to your own project.