How do we handle null check for a datatable

Help Studio
1

I had a scenario to check the count of datatable but I need to handle a null check as well on top of it

2

Hey @Umesh_p

its easy just follow the below steps

Use if condition
IsNothing(Dt)

True → null ---- take necessary action
False-> not null

Regards,
Nikhil

2 Likes
3

A datatable should never be null. You should always initialize it with “New System.Data.DataTable” in the Default value in the variables pane.

To check if there are rows you use an If activity with myDT.Rows.Count > 0

4

Hey @Umesh_p ,

Please refer below thread

Hope it helps you out!

5

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