CODEWITHSUNDEEP
sqldatareader
abramlimpin
abramlimpin

Reputation: 5077

SqlDataReader: Combine Records in One String with Delimeters

I would like to combine 2 or more records in a single string based from SqlDataReader data.

SqlDataReader data = cmd.ExecuteReader();
string category = "";
while (data.Read())
{
    category = data["Column1"].ToString() + ", " + category;
}
ltCategory.Text = category.TrimEnd(',');

I have 2 existing records and the ltCategory.Text displays Record1, Record2,

I want to use the following format:

SOLUTION

SqlDataReader data = cmd.ExecuteReader();
string category = "";
while (data.Read())
{
    category += ", " + data["Column1"].ToString();
}
ltCategory.Text = category.TrimStart(',');

Upvotes: 0

Views: 86

Answers (1)

Thomas Wood
Thomas Wood

Reputation: 819

Change category = data["Column1"].ToString() + ", " + category; to category += data["Column1"].ToString() + ", ";

ltCategory.Text = category.TrimEnd(',');

This might need to be changed as well to:

ltCategory.Text = category.TrimEnd(', ');

Upvotes: 1

Related Questions