Convert a list to comma separated string without loop

[kadiravan_kalidoss (Kadiravan K)]

I have a list with string values. I want to store all values from my list to a variable with comma separated without using loop.

Thanks!

[q-z (Remus Pirvu)]

Hello, @kadiravan_kalidoss! This can be made using some vb.net code and some specific methods. Just take a look over these:
VB.NET Convert List to String - Dot Net Perls
vb.net - Convert List of String to a String separated by a delimiter - Stack Overflow
Basically, this should work:

String.Join(",", myListOfStrings.ToArray())

I think I did this at a certain point, if those links don’t help you just let me know and I can actually look for it and find the solution when I have a bit of time.

[kadiravan_kalidoss (Kadiravan K)]

it works flawlessly…!

Same way can we convert a datatable column values to comma separated string? Without using loop!

[q-z (Remus Pirvu)]

Awesome that it worked! For datatable column values to a string without using a loop you can also use a line of vb.net code:

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

Let me know if it works for you!

[kadiravan_kalidoss (Kadiravan K)]

Thank you !!
its working fine…!