repeater output

[Bijoy Naick]

I have a query that spits out a single column of text rows. For example,

City
"London"
"New York"
"Toronto"
"Chicago"

I have a repeater that I'd like to use to spit out the output as
follows:

London, New York, Toronto, Chicago

How do I do that?? I use a repeater because I am using multiple nested
repeaters, datasets and relations to display "merged" output from
multiple queries. All works fine except for the city listing..

I get London, New York, Toronto, Chicago, (noticed the extra comma at
the end).

Repeater code is as follows

<asp:Repeater ID="cityList" Runat="server" DataSource='fasd'>
<ItemTemplate>
<%# Container.DataItem("city") %>,
</ItemTemplate>
</asp:Repeater>

 

[Ben Lucas]

You're on the right track. However, the repeater is doing exactly what you
told it to do (including adding the comma at the end of every item). Try
this instead:

<asp:Repeater ID="cityList" Runat="server" DataSource='fasd'>
<ItemTemplate>
<%# Container.DataItem("city") %>
</ItemTemplate>
<SeparatorTemplate>
,
</SeparatorTemplate>
</asp:Repeater>

Note that I removed the comma from the ItemTemplate and added a
SeparatorTemplate. The SeparatorTemplate will render between items.