Repeater syntax question

[Kevin Vogler]

I have a stored procedure that returns a select with a variable number of
columns based on the data. By reading the number of columns returned, I
construct a stringbuilder with the html tags for a table with the
appropriate headings, body data and footer. I can response.write the
results which works fine but since I'd like to position the information on
the page, the repeater control seems to make the most sense. I've bound the
repeater to the datareader source but would like to set the header, item and
footer templates with the stringbuilder value at the appropriate points in
the code. How do I get the stringbuilder into the templates?

Here's a snipet of code

With sbHeader

..Append("<table width=""100%"" border=""0"" cellspacing=""1""
cellpadding=""3"" bgcolor=""#CCCCCC"">")

..Append("<tr><td bgcolor=""#FFFFFF"">")

..Append("</td><td bgcolor=""#FFFFFF"" align=""Left"">")

..Append("<font face=""Arial, Helvetica, sans-serif""
size=""1"">&nbsp;Customer ID<br>Customer Name<br>UPS Tracking
ID</font></td>")

For i = 6 To dr.FieldCount - 1

..Append("<td bgcolor=""#FFFFFF"" align=""center""><font face=""Arial,
Helvetica, sans-serif"" size=""1"">")

..Append(Replace(dr.GetName(i).ToString, "_", "<br>") & "</font></td>")

i = i + 1

Next i

..Append("<td bgcolor=""#FFFFFF"" align=""center""><font face=""Arial,
Helvetica, sans-serif"" size=""1"">Weight Total</font></td></tr>")

' Obviously this doesn't work but what does? Repeater1.HeaderTemplate =
sbHeader.toString

End With

Many Thanks

Kevin Vogler