Looping through rows in a DataView

Question

The DataView object doesn't have a Rows property like DataTable.

How do I loop through the rows of a DataView?

Answer 1

The DataView object itself is used to loop through DataView rows.

DataView rows are represented by the DataRowView object. The DataRowView.Row property provides access to the original DataTable row.

C#

foreach (DataRowView rowView in dataView) {     DataRow row = rowView.Row;     // Do something // } 

VB.NET

For Each rowView As DataRowView in dataView     Dim row As DataRow = rowView.Row     ' Do something ' Next