while working on a project i found my self needing to convert a collumn of Double to String to format to be sent in an email.
now i know there are atleast 2 ways to do this…
Option 1) using standard for each row Activity with an Assign row(“ColumnName”) = Convert.ToDouble(row(“ColumnName”)
Option 2) Using Invoke Code Activity with the following arguments and code
dt AsDatatable In/Out
row AsDatarow In
For Each row in dt.AsEnumerable
row(“ColumnName”) = Convert.ToDouble(row(“ColumnName”)
i was just wondering what is the best practice is when it comes to these small loops that would have a single assign activity in them.