Comma seperated columns

[Cushing_Gregory]

Hi I am trying to use c# to generate a comma separated string of columns for all the columns in a data table. I see commonly used stuff on the forum, but I cant seem to find something that fits this request.

Can someone help me out with what this would look like?

[Anil_G (Anil Gorthi)]

@Cushing_Gregory

Please try this

String.Join(",",dt.Columns.Cast<DataColumn>().Select(x => x.ColumnName).ToArray())

cheers

[Cushing_Gregory]

@Anil_G

String.Join(“,”,dt.Columns.Cast().Select(x => x.ColumnName).ToArray())

[Anil_G (Anil Gorthi)]

@Cushing_Gregory

Please change dt as per your datatable name …May be it is bulkdt or testdt for you

cheers

[Cushing_Gregory]

It is using the correct dt which is an argument.

[supermanPunch (Arpan)]

@Cushing_Gregory

image1920×1080 332 KB

Hi @Cushing_Gregory ,

From the above screenshot we see that it is VB project and not C#.

Try the below with the similarity as in the above post :

String.Join(",",DT.Columns.Cast(Of DataColumn).Select(Function(x)x.ColumnName).ToArray)

[Cushing_Gregory]

Appreciate the help, my eyes are rough this morning. Makes sense the invoke code c# code block ran the code. I will test out and report back.