How do I limit a foreach loop n runs?

Question

Assuming I have the following loop:

foreach (DataRow dr in table.rows)
{
    ...
}

How do I keep it from running more often than n times?

Answer 1

In case rows is actually just from DataTable.Rows, the simple Take answers given won't work as DataRowCollection only implements the non-generic IEnumerable interface, whereas LINQ needs the generic one. You'll need something like:

// Uses DataTableExtensions.AsEnumerable
foreach (DataRow dr in table.AsEnumerable().Take(50))

or

// Uses Enumerable.Cast
foreach (DataRow dr in rows.Cast<DataRow>().Take(50))

Answer 2

You could try

using System.Linq;
...
...
...
foreach (DataRow dr in rows.Cast<DataRow>().Take(50)) { }

Note that you have to call Cast<DataRow>() in order to convert DataRowCollection to IEnumerable<DataRow>, which will allow you to use the Take() extension method.

Answer 3

Option 1: Have a running counter:

var i = 0;
foreach (DataRow dr in rows)
{
    i++;
    if(i >= 50) break;
}

Option 2: Use a for-loop

for(int i = 0; i <= 50; i++) {
    // This might actually crash if there are fewer than 50 rows
    var row = rows[i]; 
}

Answer 4

Try this:

foreach (DataRow dr in table.Rows.Cast<DataRow>().Take(50))
{
    //your logic
}

Answer 5

Ideally, modify your original query to only return 50 rows. There's no point in fetching more than you want to use.

Others have provided good alternatives if this is not an option.