Looping through rows in a DataView

.net loops dataview
Alex Angas picture Alex Angas · Sep 15, 2009 · Viewed 116k times · Source

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

How do I loop through the rows of a DataView?

Answer

Alex Angas picture Alex Angas · Sep 15, 2009

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

Related questions

How to enumerate an enum

How can you enumerate an enum in C#? E.g. the following code does not compile: public enum Suit { Spades, Hearts, Clubs, Diamonds } public void EnumerateAllSuitsDemoMethod() { foreach (Suit suit in Suit) { DoSomething(suit); } } And it gives the following compile-time error: …

Read More
How do I skip an iteration of a `foreach` loop?

In Perl I can skip a foreach (or any loop) iteration with a next; command. Is there a way to skip over an iteration and jump to the next loop in C#? foreach (int number in numbers) { if (number < 0) { // …

Read More
foreach vs someList.ForEach(){}

There are apparently many ways to iterate over a collection. Curious if there are any differences, or why you'd use one way over the other. First type: List<string> someList = <some way to init> foreach(string …

Read More