Hot to copy values from Datatable column in to existing List

[qwerty1]

Hi, i was lookig for some help with copying values for a datatable column in to an existing list. When i try the following it just overwrites the values in the list ( From row in dt.AsEnumerable() Select Convert.Tostring(row(“ColumnName”)) ) .ToList.Copy

How can i simply append without using a loop?

Thanks

[ppr (Peter)]

dtList = dt.AsEnumerable().Select(Function (x) x("ColumnName").toString.Trim).toList
newList = oldList.Concat(dtList).toList

[ppr (Peter)]

Also have a look here:

[HowTo] LINQ - First Start # Concat | Append | Prepend Operator

This HowTo gives an introductory overview of the conjunction operators: Concat, Append, Prepend Introduction The conjunction operators are used to add the item(s) to a particular set of items. Concat, Append, Prepend Operator The Concat Operator combines a set of items with another set of items The Append Operator adds an item to a set of items on the end The Prepend Operator adds an item to a set of items on the begin Overview I – Input P – Processing O – Output {"A","B"} / {"…

[qwerty1]

@ppr [quote=“ppr, post:2, topic:537242”]

dt.AsEnumerable().Select(Function (x) row("ColumnName").toString.Trim).toList
newList = oldList.Concat(dtList).toList

[/quote]

Thank you for your quick reply. when i try to use, i recieve the error ‘row is not declared’. Could you help please?

[vishal.kp (vishal)]

Hi @qwerty1 ,

In addition to @ppr method, you can also use invoke method to add to the list as shown below using the AddRange function:

Pass your expression in the parameters.

Regards,

[ppr (Peter)]

@qwerty1

row is not declared

did correct the statement in origin post above