Loop through the rows of a particular DataTable

For Each row As DataRow In dtDataTable.Rows
    strDetail = row.Item("Detail")
Next row

There’s also a shorthand:

For Each row As DataRow In dtDataTable.Rows
    strDetail = row("Detail")
Next row

Note that Microsoft’s style guidelines for .Net now specifically recommend against using hungarian type prefixes for variables. Instead of “strDetail”, for example, you should just use “Detail”.

FWIW, I’d really like to see support for this (and also the async equivalent) built directly into ADO.Net.

Leave a Comment