A little while back I needed to create a comma-delimited string to parse into my SQL Query. My first attempt in creating my comma-delimited string involved using a StringBuilder class and appending a comma at the end of each of my values via a loop. However, I found that my application would error when parsing my comma-delimited string into my SQL query due to the fact a comma was added to the end of my string.
After some research on the MSDN website to solve my problem I found a solution and it was simpler than I thought. The .NET Framework already has a class called CommaDelimitedStringCollection and it is pretty simple to use as the following example shows:
public partial class CommaPage : System.Web.UI.Page
protected void Page_Load(object sender, EventArgs e)
//Create a collection to parse to CommaDelimitedStringCollection class
List<string> cars = new List<string>();
//Create instance of CommaDelimitedStringCollection
= new CommaDelimitedStringCollection() ;
//Iterate through cars collection and add to commaCollection
foreach (string item in cars)
//Read out list of values
The output of the example above would be: "Volvo, VW, BMW, Ford".
So pretty much the .NET Framework's CommaDelimitedStringCollection class did all the work for me.