Rad Scheduler Issue

1 posts, 0 answers
  1. Waqar
    Waqar avatar
    1 posts
    Member since:
    Sep 2011

    Posted 12 Sep 2011 Link to this post

    Hi i am using RAD Scheduler. The Problem is when i bind RAD Scheduler in Resource Grouping mode its not showing Appointments. If i remove resource grouping the scheduler is working fine.

    I have two tables one for Projects (Appointments ) and other for Techs ( Resources.). Both table have FK relationship. I tried all possible way of binding ( In Memory DataTable with Custom fields required by Scheduler) and finally i m using Sql Data Sources for Projects ( Appointments) and Techs (Resources.) The FK relationship is defined. 

    <telerik:RadScheduler ID="RadScheduler1" runat="server" DataSourceID="sdsProjects"
             Skin="Office2007" Height="100%" Width="100%"  ShowFooter="False"
             DataKeyField="project" DataStartField="Start" DataEndField="End" 
             DataSubjectField="Cust" CustomAttributeNames="Cust,Location, Tech" RowHeight="37px"
                OnAppointmentCommand="RadScheduler1_AppointmentCommand" 
                OnAppointmentInsert="RadScheduler1_AppointmentInsert" GroupBy="Tech">
                <AdvancedForm Modal="true" />
    And here is Resource defination

            <ResourceTypes>
                    <telerik:ResourceType DataSourceID="sdsResources" ForeignKeyField="Assignedto" 
                        KeyField="uID" Name="Tech" TextField="UserName" />
                </ResourceTypes>

    here are two DataSources.

    <asp:SqlDataSource ID="sdsResources" runat="server" 
            ConnectionString="<%$ ConnectionStrings:MyConn %>" 
            
            SelectCommand="Select * From Techs" >
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="sdsProjects" runat="server" 
            ConnectionString="<%$ ConnectionStrings:Mycon %>" 
            SelectCommand="sched_GetSchedule" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:Parameter Name="schedDate" Type="DateTime" />
            </SelectParameters>
        </asp:SqlDataSource>


    Any help will be greatly appreciated. 

    Thanks
Back to Top