Lets say I have two tables

First Table is OrdersTable-- Fields below OrderID RecieverID (Relation with CustomerID on Second Table) SenderID (Relation with CustomerID on Second Table) Date vs.vs

Second table is CustomersTable-- Fields below

CustomerID CustomerName

getting OrdersTable collection and binding gridView on asp.net

trying to get Customer Name each of IDs by using

for Reciever <ItemTemplate> <%# Eval("CustomerTable.CustomerName")%> </ItemTemplate>

for Sender <ItemTemplate> <%# Eval("CustomerTable.CustomerName")%> </ItemTemplate>

but strangely I m gettin always reciever name.

how to say in eval() which Id to get or any suggestion?

In the Orders entity, for each of the FKs there is a different field mapped on the related entity.

for example: Customer (for ReceiverId) *& Customer_ for (SenderID), if you want you may rename them from the designer to better reflect the meaning.

Anyway so your code should look like:

for Reciever
<ItemTemplate>
                    <%# Eval("Customer.CustomerName")%>
</ItemTemplate>

for Sender
<ItemTemplate>
                    <%# Eval("Customer_.CustomerName")%>
</ItemTemplate>

Thank you so much!