Convert datatable column values in a comma separated string in c#

Sujeet Raman

I have a datatable who has two column with values as below

NO NAME
1 A
2 B
3 C
4 D

So what I want ONLY NAME values in a string with comma separated and single quoted like below

string names= 'A','B','C','D'

How will I get input as an sql query

example : "select names in ('A','B','C','D')";

how to add single quotes? i may have 100 data

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Srinivasan Ramamoorthi4y ago
Accepted answer
Try this one
```
string s = string.Join(", ", dt.Rows.OfType().Select(r => r[0].ToString()));
```
Sachin Singh4y ago
The easies one is
var list = dt.AsEnumerable().Select(x => x["Name"].ToString());
string value = string.Join(",", list);
Vikas Panwar4y ago
1. DataTable dt = new DataTable("User");
2. dt.Columns.Add(new DataColumn("ID", typeof(int)));
3. dt.Columns.Add(new DataColumn("Name", typeof(string)));
4. dt.Rows.Add(100, "Test1");
5. dt.Rows.Add(235, "Test2");
6. dt.Rows.Add(250, "Test3");
7. string commaSeparatedString = String.Join(",", dt.AsEnumerable().Select(x => x.Field<string>("Name").ToString()).ToArray());