Clear datatable and get Null value

[Emi_Zehcnas]

Hi,

I would like to clear a DataTable, but the columns are not delete. I use the Clear datatable activitie.

Any ideas ?

Thank you

regards,

Emi

[lakshman (Ganta lakshman)]

@Emi_Zehcnas

Have you specified DataTable variable to Clear dataTable or not ? Please check once.

After this Activity try to print this value:

YourDT.rows.count

If the above will print output as 0 then it cleared the data.

[Palaniyappan (Palaniyappan P)]

Hi @Emi_Zehcnas
you were almost done
Clear datatable activity will actually clear the records in the datatable except the columnname
–pass the datatable variable (lets take its name as outdt - a variable of type datatable) as input to this activity
–for more info on this

Clear Data Table

–as @lakshman said to check with the rows whether it got deleted or not
use a write line activity and mention like this
outdt.Rows.Count.ToString
–check with the count value in the output panel and it would be 0 and if so you are good

hope this wuld help you
Kindly try this and let know for any queries or clarification
Cheers @Emi_Zehcnas

[Emi_Zehcnas]

@Palaniyappan

columnname

Thank for answers, I would like to delete datatable and columnname

I misspoke

Thanks,

Regards

[rado]

If you want to delete whole data in DataTable variable ( data and headers ) then just create a new instance of it like: YourDT = New System.Data.DataTable - it will create new empty instance of DT

[Emi_Zehcnas]

@rado

New System.Data.DataTable

Nice, it works, thanks you !!!

[rado]

great ! Please tag as solved

[Emi_Zehcnas]

done !