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
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