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:
- Record1
- Record1, Record2, Record3
SOLUTION
SqlDataReader data = cmd.ExecuteReader();
string category = "";
while (data.Read())
{
category += ", " + data["Column1"].ToString();
}
ltCategory.Text = category.TrimStart(',');