Author: tihomir_wwf | Posted on: 8/8/2008 1:49:58 AM | Views : 425

 Hi,
 
I'll try to explain my question with an example:
in db, I've 3 tables A, B, C, id is primary key, A_id is foreign key for table A, B_id is foreign key for table B

A(id, txt) <- B(id, A_id, txt) <- C(id, B_id, txt)

 
in may page, I've gridview with LinqDataSource which display rows from C:

<asp:GridView ID="_someGV" runat="server" DataSourceID="_someDS"></asp:GridView>


<asp:LinqDataSource ID="_someDS" runat="server"
      ContextTypeName="someContext"
      TableName="C"
      Where="B.A_id == 100">

</asp:LinqDataSource>
 
Problem is that I want to show rows from C by  A.id,
 and the Where:    Where="B.A_id == 100

Go to the complete details ...