System.Data.Datatable convert to string or Integer

[DinukaThilakarathne]

Hi All,

Please tell me how to convert System.Data.Datatable to string value or integer value without assign or with assign

Thanks

[hasib08 (Motiwala Hasib)]

You can use Output Datatable activity which will give you the output in string variable.

[DinukaThilakarathne]

Hi @hasib08

Can’t we use it like a method
can you provide a example please

Thank you

[hasib08 (Motiwala Hasib)]

Refer this post

How to convert datatable to string value

I dont know if you still need a solution. However, i have learned that the more versatile way to log or write all to a string is using string.join and LINQ. Basic case and works always: string.join(Environment.NewLine, yourDataTable.Rows.Cast(of DataRow).Select(function(row) string.join(",",row.ItemArray)) Just copy and paste and change yourDataTable to your variable. In case you want to understand and goo deeply you can do a lot of changes some of them: If you add take()/skip() bef…