Error in linq when no datarows found

[yash.choursia]

Hi Team,

I have written this code. It is working fine but it is throwing error when it does not contain any datarow.

How to solve this?

[supermanPunch (Arpan)]

Hi @yash.choursia ,

Could you check the below post :

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…

[rodrigo.simao]

Hello! Create an “IF” activity and the condition should be “Value that you want” = NULL
THEN:
ELSE: Add data row

Hope it helps! Cheers.

[postwick (Paul Ostwick)]

I think it’s the .CopyToDatatable that causes this error. What I did was create a list(of datatrow) variable and assign the linq expression to it without the .CopyToDatatable part. Then you can do an If activity with listVar.Count>0 as the condition. Inside the if, do your assign notvalidmaterial_DT = listVar.CopyToDatatable

[Quenton_Wayne_Rebello]

If the issue is that the linq throws an error when the linq result is empty. Then convert the linq to array using .ToArray in end instead of .CopyToDataTable.

Then check if the array is null, if it is null - output datatable is empty. If array is having value then output datatable is equal to the array