filterDt.Select("[Name]='Tina'").CopyToDataTable is throwing the source contains no data rows error

Help Studio
, ,
7

Hi,

CopyToDataTable methods throws exception if instance has no rows.
To avoid this, first, set result rows of Select method into datarow array (arrDr). Then check if arrDr has any items using Any method in condition of IF activity.
If arrDr has one or more rows, convert it to DataTable using CopyToDataTable method.
If arrDr has no row, set empty datatable from filterDt using Clone method.

Hope this helps you.

Regards,