How to check LINQ have no datarows?

[Lori (Li)]

I have LINQ as below:
(From d In in_DataTable.AsEnumerable
Where d(“OU_NAME”).tostring.Trim.Equals(row(“OU”).ToString)
Let ex=d(“Log_File Name”).tostring.Trim().toUpper()
Where String.IsNullOrWhiteSpace(ex)
Select r=d).CopyToDataTable()
When there is no data, system exception and give Error message:
Assign: The source contains no DataRows.
How I check this place and don’t thrown the exception.

[ppr (Peter Preuss)]

[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.AsE…

[mkankatala (Mahesh Kankatala)]

Hi @Lori

Before using the linq expression, Use an If condition to check the datatable contains any rows or not.

Take an If activity and give the below condition,

in_DataTable.rows.Count>0

In then block insert the assign activity which contains the linq expression.
In else block insert the assign activity to handle the exception.

Hope it helps!!

[Yoichi]

Hi,

I think it’s better to output result as DataRow array type, next check if it has datarow, then convert it to datatable, as the following.

Regards,