27

I'd like to use a DataGridViewRowCollection in a LINQ expression using extension methods and lambda expressions. Unfortunately, the extension methods are for types IEnumerable<T>, which DataGridViewRowCollection doesn't implement. The funny thing is, I can use LINQ here with the SQL-like syntax:

IEnumerable<DataGridViewRow> lRows = from DataGridViewRow row in dgvGrid.Rows 
                                     select row;

After doing that, I can use LINQ extension methods:

foreach (DataGridViewRow lRow in lRows.Where(row => row.index > 4)) { ... }

Is there any way I can convert my DataGridViewRowCollection to an IEnumerable<> without using that long first statement? The same thing applies to DataGridViewCellCollection and DataGridViewColumnCollection.

ps. I'm using .net framework 3.5

davmos
  • 9,324
  • 4
  • 40
  • 43
Mashmagar
  • 2,556
  • 2
  • 29
  • 38

1 Answers1

48

Yes, do this:

var rows = yourDataGridViewRowCollection
               .Cast<DataGridViewRow>()
               .Where(row => row.index > 4);

This uses the Enumerable.Cast extension method:

The Cast<TResult>(IEnumerable) method enables the standard query operators to be invoked on non-generic collections by supplying the necessary type information. For example, ArrayList does not implement IEnumerable<T>, but by calling Cast<TResult>(IEnumerable) on the ArrayList object, the standard query operators can then be used to query the sequence.

Andrew Hare
  • 344,730
  • 71
  • 640
  • 635
  • 5
    For the record, `OfType()` is also a viable choice. The only difference is that `OfType` will discard anything it can't convert, and `Cast` will throw an exception. – Bobson Oct 15 '12 at 18:24