Needed Explanation

[Gokul001 (Gokul Balaji)]

Hi
Can anyone explain this expression ?

dtExported.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(“”))).CopyToDataTable()

[ppr (Peter)]

Its a LINQ within Method syntax:

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operators Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start # All Operato…

dtExported.Rows.Cast(Of DataRow)()
Similar to dtExported.asEnumerable - makes the datarows available for the LINQ
.Where - filtering
(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(“”)
Filter expression: All Column Values from the looped datarow are not blank
)).CopyToDataTable()**
us the datarows passed the filter and copy it to a datatable

Rewritten to Query Syntax:

(From d in dtExported.AsEnumerable
Where d.ItemArray.All(Function (x) Not (isNothing(x) OrElse String.IsNullOrEmpty(x.toString)))
Select r = d).CopyToDataTable