Sub select in LLBGEN nested repeaters how

Posts   
 
    
DAVE30B
User
Posts: 8
Joined: 12-Oct-2007
# Posted on: 15-Oct-2007 15:55:29   

Got my other problem fixed thanks guys I am building a survey builder for my app and i need to pull out the survey question and answers I have them pulling out fine with a one to many relationship set up in database my question is

how do i do a group by two group all the Answers for a certain question id so they only apear once in a asp:reapeater before youwould do nested repeaters and link that way what is the easiet way in llbgen

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39749
Joined: 17-Aug-2003
# Posted on: 16-Oct-2007 11:13:48   

As the question has a 1:n relation with Answer, you can fetch with a prefetch path the question AND the answers in one call, so you then get a QuestionEntity instance with its Answers collection filled with the Answer entities related to that question, similar to Customer and its Order entities.

As for nested repeaters, you could have a look at HnD, its Start page (the section + forum page): http://www.llblgen.com/hnd

It's the sourcecode of this forum system. The source is for LLBLGen Pro v2.0 (not updated yet for v2.5, we will do that shortly), though it will show you how to do nested repeaters and databinding. simple_smile

Frans Bouma | Lead developer LLBLGen Pro