Convert List Combo into Comma-Separated String in c#

Question

My code is as below:

List<string> colorList = new List<string>();

....

sCombo = reader["Combo"].ToString();
colorList.Add(sCombo.ToString());

....


foreach (var Combo in colorList)
{
   Response.Write(string.Join(",", Combo));
}

Output: D410D430D440D420 instead of D410,D430,D440,D420

What is the most simple way to convert the List<string> into a comma-separated string?

EDIT #01

Your suggestion working, but I need this new output :

'D410','D430','D440','D420'

Because use this string on sql query.

Thank you

Possible duplicate of Using LINQ to concatenate strings

NibblyPig
– NibblyPig

2019-02-21 10:37:22 +00:00
Commented Feb 21, 2019 at 10:37 — NibblyPig
– NibblyPig, Commented Feb 21, 2019 at 10:37

Marcin Piwowarski · Accepted Answer · 2019-07-23 14:19:59Z

7

I think this would be very handy

var colorList = new List<string>() { "D410", "D430", "D440", "D420" };
string commaSeparated = string.Join(",", colorList);                      
Console.WriteLine(commaSeparated);

or try solution based on Linq

Console.WriteLine(colorList.Select(s => s + ",").Aggregate((s, q) => s + q).TrimEnd(','));

The output

D410,D430,D440,D420

Edit

string result = string.Join(",", colorList.Select(e => "'" + e + "'"));
Console.WriteLine(result);

will give you

'D410','D430','D440','D420'

edited Jul 23, 2019 at 14:19

answered Feb 21, 2019 at 10:42

Marcin Piwowarski

3,0966 gold badges30 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dan Dumitru · Accepted Answer · 2019-02-21 10:37:19Z

4

Without a foreach:

Response.Write(string.Join(",", colorList));

answered Feb 21, 2019 at 10:37

Dan Dumitru

5,3251 gold badge36 silver badges47 bronze badges

1 Comment

Chevy Mark Sunderland Over a year ago

Your suggestion working, but I need this new output : 'D410','D430','D440','D420' Because use this string on sql query. Thank you

er-sho · Accepted Answer · 2019-02-21 11:02:16Z

1

You need to output like this => 'D410','D430','D440','D420'

So try below,

string result = string.Join(",", colorList.Select(x => $"'{x}'"));
Response.Write(result);

What we did above?

Answer: First we flatten each item in your list with a single quoted ('') surrounding string and then we just pass this newly generated flatten result to join method of string with a comma (,) to get your desired output.

Output: (From Debugger)

edited Feb 21, 2019 at 11:02

answered Feb 21, 2019 at 10:55

er-sho

9,8212 gold badges17 silver badges26 bronze badges

Collectives™ on Stack Overflow

Convert List Combo into Comma-Separated String in c#

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related