Source contains no datarow (LINQ)

[Miketb]

Hi all,

Facing an issue when trying to filter a datatable using LINQ.

DTFiltered = DTUnfiltered.AsEnumerable.Where(Function(r) CStr(r(“ColumnA”).ToString).Contains(“TEST”)).CopyToDatatable

With the above statement, I get the error “Source contains no datarow”. This is true since DTUnfiltered does not always contain TEST. To solve this, I created the following IF statement:
DTFiltered=if(DTUnfiltered.AsEnumerable.Where(Function(r) CStr(r(“ColumnA”).ToString).Contains(“TEST”)).Any(),DTUnfiltered.AsEnumerable.Where(Function(r) CStr(r(“ColumnA”).ToString).Contains(“TEST”)).CopyToDataTable(), DTHitsAchternaam.Clone)

While this statements works perfectly, it seems a bit unnecessary to loop the DT twice. Does anyone have an alternative for the second loop through the DT?

Kind regards,
Mike

[supermanPunch (Arpan)]

@Miketb Check this post :

Filter expression in data row

@BOTFORCE Actually there is an additional Step involved in it, Which I believe I have not said. When the CollectedDataDT has no rows Corresponding to entry_id which is matching in Other DT , it gives out an Error. There are mainly two ways of Handling that error: You can use a Try Catch Method, Where you enclose the Assign Statement in Try and use another assign Statement in Catch Block to assign an Empty Datatable. You can perform thsi as shown in the Screenshots below [dtarray] [dtarray1…

[Miketb]

Thank you!