How can I filter empty rows from datatable without using a loop?

Question

I have a scenario where a datatable can contain a large number of rows. As a result, I cannot repeat and update data using a loop.

I tried the following code,

from row in table.AsEnumerable() where table.Columns.Any(col => !row.IsNull(col)) select row; 

But I can not find a definition for Any () . Is there any namespace I should use to get Any ()?

Any body, please tell me how to fix this or suggest any alternative solutions.

Answer 1

In addition to using the System.Linq namespace, you also need to know its types. DataTable.Columns not a common collection (it implements only IEnumerable not IEnumerable<T> ), and the compiler cannot infer a type. You need to do something like this:

 from row in table.AsEnumerable() where table.Columns.Cast<DataColumn>.Any(col => !row.IsNull(col)) select row; 

Answer 2

The Any() method is in the System.Linq namespace. The method lives in the Queryable class.

Answer 3

use the system.linq namespace if the wireframe version is greater than 2

Answer 4

you should include the following:

 using System.Linq;