Add to datatable
I have an existing DataTable with one row (will always be one). I need to add a column and value to this data table. What's the best way to do this - dictionary?
Thanks,
James
0
-
Hi James,
You can do this with two Assign activities. The first will add the new column to the row, and the second will set the value:
newColumn = myDataTable.Columns.Add("newColumnName")
myDataTable.Rows(0).Items("newColumnName") = "newColumnValue"
-Victoria
0
Please sign in to leave a comment.
Comments
1 comment