Hi All, I am trying to filter the data table and since there are no rows with that filter condition it’s throwing an exception saying “The source contains no DataRows” How to proceed further? What should happen: If there are no rows then I need to get the count as “zero” and write some logic towa…

Hi @Krithi1 Can you try like below rowCount = filterDt.Select("[Name]='Tina'").Length If rowCount is 0, no rows match. Otherwise, proceed with logic. Regards,

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

Help Studio

Krithi1 December 10, 2024, 1:10pm 5

@AJ_Ask

The actual table has rows. Only when i filter there are no rows.this is not a solution for me i believe

Topic		Replies	Views
Error the source contains no datarow Studio	6	1685	December 8, 2021
Filter Table -> Source contains no data rows Help datatable , excel	1	2925	September 21, 2018
Issue filtering when the source can contain no DataRows Help excel , activities	5	6971	October 29, 2018
Error: "The Source contains no DataRows" with If Condition: "Datatable.Select("[column1]=’”+row(0).ToString"'").CopyToDataTable is Nothing OrElse Datatable.Select("[column1]=’”+row(0).ToString"'").CopyToDataTable.Rows.Count=0" Help datatable , activities , question	7	2380	December 20, 2019
How to check if datatable has no rows? Help	10	10456	October 29, 2018

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

Related topics