sarmadirizvi 0 Newbie Poster

Hi friends!

I have a listview that shows the user the details of the members who have sent friendship request. The table from which the data come has two fields namely, sender_id[id of the one who sends friendship request] and receiver_id[id of the one to whom the request is sent].
There will be two columns in the listview. The first would show the pic and the name of the user. The problem is that how am I going to show the pic and the name if the table from where the data come does not contain these info. I know that the sender_id can be used to fetch the pic and name of the sender, but how should it be done?
Earlier I would do something like <%#Eval("fieldName")%>. But in the above described scenario the field is not present in the current table but the other one.

So what should I put in the place of question marks[?] in the below given html.

<ItemTemplate>
<tr>
<td>
<asp:ImageButton ID="sender_image" Width="50px" Height="50px" ImageUrl="?????" runat="server" />
</td>
<td style="padding-left:10px; ">
<a href='ViewProfile.aspx?user_id=<%# Eval("sender_id") %>'>
<%#Eval("?????")%></a>
</td>
</tr>

</ItemTemplate>

Any solution friends?