convert foreign key value in repeater

[TJS]

while creating values in a repeater, I want ot replace the foreign key value
with a text value.

<asp:repeater id="scores" runat="server" OnItemCreated="Scores_itemCreated">
.....
<ItemTemplate>
<tr bgcolor="#EEEEEE"" >
<td><%# container.DataItem("idEvent") %></td>
.....


i was thinking of using OnItemCreated with a query to lookup the text name
and reassign it to be the display but can't figure out how to do this.

Any suggestions ?

 

[Karl Seguin]

OnItemDataBound seems like the smart way to do it:
http://openmymind.net/index.aspx?documentId=8

alternatively, you could use

<%# GetItemName(Container.DataItem("idEvent")) %>

and have a function:

protected string function GetItemName(byval eventId as string)
...
end function

read the tutorial, talks about both methods..

Karl

 

[TJS]

thanks, the function idea works great.

Just a note on your article, the content has to be scrolled back and forth
in order to read it.

I have a high resolution screen , 15 in monitor and it still didn't fit.

 

[Karl Seguin]

ya...I'll fix that one day

thx.

karl