Clear Datatable

Help Activities
,
1

I wanted to clear datatable if it contains header. Was suggested to use DataTable.Columns.count > 0 to check. But I encounter an issue if the datatable hasn’t been populated yet as null is not an instance of an object. Please advise.

2

Hi @QTH ,
Have you tried activity
image
regards,
LNV

3

you can do a null check

IF(Not isNothing(YourDatatableVar),YourDatatableVar.Clone, new DataTable() )

1 Like
4

HI

How about the following?

dt = New DataTable()

image

Regards,

5

HI @QTH

You can try this
if condition = dt.columncount>0

image
image460×528 12.1 KB

6

@QTH

image

7

Thanks all for the replies but as shared in my initial post there may be instances where the datatable isn’t populated yet and hence the solutions asking to count the columns will return an error. The suggestion to do a null check seems to work for non populated datatable.
Same goes for the approach to just reassign it as a new datatable but I’ve yet to check.

Thanks all for the advice.

8

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