Put data of column datatable in one string variable

[hansgeeroms]

Hi everybody,

I have a little question about getting values from a column of a datatable in one string.
When i have a column like this:

abc
def
ghi
jkl

I want this in one string variable like this:
abc,def,ghi,jkl

This column can be dynamic, so it can be a column like this:
abc
def
ghi

I’m struggling with list of strings or in for each from datatable.

[HareeshMR (Hareesh Madasi)]

You can loop through the data table and form that particular column as a string by concatenating the values one after the other @hansgeeroms

[kadiravan_kalidoss (Kadiravan K)]

Hi Greetings!

dataTable.AsEnumerable().[Select](Function(x) x(“Column1”).ToString()).Aggregate(Function(a, b) String.Concat(a, “,” & b))

Please try this…!

Thanks!