Creating a Comma Separated List from DataTable Column

[jpreziuso]

Hi can anyone tell me what is wrong with this line of code? I took it from somewhere else so I am unsure of the issue. The error says “Expression expected.”

Thanks

[ppr (Peter Preuss)]

@jpreziuso
code is valid for c#
for VB do following:
ResultDB.AsEnumerable.Select(Function (x) x(“Person Person No”).toString).toArray

[jpreziuso]

Awesome, thank you. Do you know how to then take that array and create a comma separated list?

[ppr (Peter Preuss)]

@jpreziuso
lets assume following:
Assign:
left side: arrValues, datatype String()
RightSide:
ResultDB.AsEnumerable.Select(Function (x) x(“Person Person No”).toString).toArray

Assign:
leftside: csvString - Datatype: String
RightSide:
String.Join(“,”,arrValues)

[jpreziuso]

Perfect, thank you