After a few hours of searching I couldn't find a solution to this issue so I figured I'd try a post. I have stored procedure that queries 3 tables and retuns 1 set of results. When I execute the sproc using the following code db.GET_TRAININGS(userID).GroupBy(s=>s.COURSE_TITLE); I get back an IGrouping container where the course title is the key and contains 2 GET_TRAINING_RESULT elements. Then I bind using rptCourses.DataSource=trainings; then databind(),etc.
What I'm trying to do is have the parent repeater show the course titles and the nested repeater show the modules for that course for the particular logged in user. Basically trying to turn a flat piece of data into heirchical data.
The stored procedure returns the following SQL Columns Course_Title, Module_Path, Module_Name,Sequence. The sproc code is below: SELECT
JOIN MODULES B on A.MODULE_ID = B.MODULE_ID
JOIN COURSES C on B.COURSE_ID = C.COURSE_ID
A.USER_ID= @USER_ID AND
A.EXPIRATION_DATE > GetDate()
The repeaters look like this of course:<asp:Repeater runat="server" ID="rptCourses" EnableViewState="false">
View Complete Post