How To add Datarow to datatable using ling query

Hello @Yoichi ,

How to add datarow in datatable using linq?


Can you share your case? We can use simply Add method in InvokeCode or LoadDataRow method etc in Assign activity.



I hava a datatable with headers as name and email
now i have to add the row value for name as dinesh and for email as


If your input collection is dictionary, the following will work.

dtAdd = dict.Select(Function(kv) dtAdd.LoadDataRow({kv.Key,kv.Value},False)).CopyToDataTable()

Then merge it to dt.


i have my input as string i have to add it to data table