String Columns together from a multi row grid

I have a Dynamic Query Running which will populate a grid with the colors on a sales order. There may be several colors. I would like to concatenate all of the colors from all rows into one text box in a string. I have the code below placing the last color into a text box. How would I make it loop and keep stringing together till all rows are done?

//Order - Colors
		DynamicQueryAdapter dqa13 = new DynamicQueryAdapter(oTrans);
		dqa13.BOConnect();
		QueryExecutionDataSet qeds13 = dqa13.GetQueryExecutionParametersByID("GS_Order_Colors");
		qeds13.ExecutionParameter.Clear();
		qeds13.ExecutionParameter.AddExecutionParameterRow("OrderNum", tbOrderOrderNumRef.Text.ToString(), "nvarchar", false, Guid.NewGuid(), "L");
		qeds13.ExecutionParameter.AddExecutionParameterRow("OrderLine", tbOrderLineRef.Text.ToString(), "nvarchar", false, Guid.NewGuid(), "L");
		dqa13.ExecuteByID("GS_Order_Colors", qeds13);
		gridOrderColors.DataSource = dqa13.QueryResults.Tables["Results"];
		foreach (System.Data.DataRow oc in dqa13.QueryResults.Tables["Results"].Rows)
		{
			if (dqa13.QueryResults.Tables["Results"].Rows.Count >=1)
			{
			tbOrderColorsString.Text = oc["Colors_GS_ColorName_c"].ToString();
			}
			else
			{
			}
		} 

And this post, does what you are trying to do as far as adding to strings.

I’m not certain that stringbuilder alone will get there. You would need RTF or HTML in order to preserve the background color. Maybe something like this? RichText Builder (StringBuilder for RTF) - CodeProject

Another option is to stack shapes instead of formatted text.

Mark W.

Thank you everybody. From all of your replies I did this:

		//Order - Colors
		DynamicQueryAdapter dqa13 = new DynamicQueryAdapter(oTrans);
		dqa13.BOConnect();
		QueryExecutionDataSet qeds13 = dqa13.GetQueryExecutionParametersByID("GS_Order_Colors");
		qeds13.ExecutionParameter.Clear();
		qeds13.ExecutionParameter.AddExecutionParameterRow("OrderNum", tbOrderOrderNumRef.Text.ToString(), "nvarchar", false, Guid.NewGuid(), "L");
		qeds13.ExecutionParameter.AddExecutionParameterRow("OrderLine", tbOrderLineRef.Text.ToString(), "nvarchar", false, Guid.NewGuid(), "L");
		dqa13.ExecuteByID("GS_Order_Colors", qeds13);
		gridOrderColors.DataSource = dqa13.QueryResults.Tables["Results"];
		string strBuilder = "";
		foreach (System.Data.DataRow oc in dqa13.QueryResults.Tables["Results"].Rows)
		{
			if (dqa13.QueryResults.Tables["Results"].Rows.Count >=1)
			{
				strBuilder += oc["Colors_GS_ColorName_c"].ToString() + ", ";
				{
					tbOrderColorsString.Text = strBuilder;
				}
			}
			else
			{
			}
		}