Check whether rows are available

Help Activities
1

Hi Everyone,

Wanted to check if a datatable doesn’t have any rows

If there are no rows/last row I need to send email

Or continue the loop

2

hi @keerthi65a

USE THIS EXPRESSION

(dt.Rows.Indexof(CurrentRow)+1).Equals(dt.Rows.Count)

here if it falls under then part …it is the last row and there would be no more rows…u can send notification

else part —continue the loop

1 Like
3

Hi

Use a if condition like this

dt.Rows.Count.Equals(1) OR dt.Rows.Count.Equals(0)

If yes it means it has only one row or zero row then goes to then block
If not else block

Cheers @keerthi65a

1 Like
4

Does it work inside for loop … because I am iterarting items

5

Hey does this work inside for loop I am iterating

6

hi @keerthi65a

above expression works as per the requirement …since u had mentioned loop earlier in post

so kindly give a try, basically i am targeting for loop index here

7

Hi @keerthi65a ,

Could you check with the below Expression :

DT.AsEnumerable.Any

Here, DT is the datatable variable, the above expression returns false if there are no rows available.

Maybe the scenario was more towards detecting the Last Row in the Datatable that was being looped, in that case, maybe we could use the below as well :

CurrentRow = DT.AsEnumerable.Last
1 Like
8

Yes it does if u r trying to validate on datatable whether it has 1 row or zero row

@keerthi65a

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.