This is a migrated thread and some comments may be shown as answers.

Rad Scheduler Issue

0 Answers 44 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Waqar
Top achievements
Rank 1
Waqar asked on 12 Sep 2011, 02:11 PM
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

No answers yet. Maybe you can help?

Tags
Scheduler
Asked by
Waqar
Top achievements
Rank 1
Share this question
or