How To add Datarow to datatable using ling query

Hello @Yoichi ,

How to add datarow in datatable using linq?

Hi,

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

Regards,

Hello,

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 dinesh@gmail.com

Hi,

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.

Regards,

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