Hello, im using sqldatasource to select the datas and configure to the schedular. However, the schedular did not show any datas.
Below are my codes and i've attach my table image:
deafult.aspx
<asp:SqlDataSource ID="SqlDataSourceSchedule" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT classDetailsID,cd.classID,classType,startDate,endDate,batch,leftSlot FROM ClassDetail cd INNER JOIN Class c ON cd.classID=c.classID WHERE locationID=1 AND batch=2">
</asp:SqlDataSource>
<br/><br/><br/><br/><br/>
<telerik:RadScheduler ID="RadScheduler1" runat="server"
SelectedView="MonthView" DataEndField="endDate" DataKeyField="classDetailsID"
DataSourceID="SqlDataSourceSchedule" DataStartField="startDate"
DataSubjectField="classType" Height="" SelectedDate="2013-07-15"
EditFormDateFormat="d/M/yyyy" EditFormTimeFormat="h:mm tt"
EnableCustomAttributeEditing="True">
<AdvancedForm Modal="True" EnableCustomAttributeEditing="True"></AdvancedForm>
<AppointmentTemplate>
<div class="rsAptSubject">
<asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
<%# Eval("classType") %>
</div>
</AppointmentTemplate>
<TimeSlotContextMenuSettings EnableDefault="True"></TimeSlotContextMenuSettings>
<AppointmentContextMenuSettings EnableDefault="True"></AppointmentContextMenuSettings>
</telerik:RadScheduler>
Below are my codes and i've attach my table image:
deafult.aspx
<asp:SqlDataSource ID="SqlDataSourceSchedule" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT classDetailsID,cd.classID,classType,startDate,endDate,batch,leftSlot FROM ClassDetail cd INNER JOIN Class c ON cd.classID=c.classID WHERE locationID=1 AND batch=2">
</asp:SqlDataSource>
<br/><br/><br/><br/><br/>
<telerik:RadScheduler ID="RadScheduler1" runat="server"
SelectedView="MonthView" DataEndField="endDate" DataKeyField="classDetailsID"
DataSourceID="SqlDataSourceSchedule" DataStartField="startDate"
DataSubjectField="classType" Height="" SelectedDate="2013-07-15"
EditFormDateFormat="d/M/yyyy" EditFormTimeFormat="h:mm tt"
EnableCustomAttributeEditing="True">
<AdvancedForm Modal="True" EnableCustomAttributeEditing="True"></AdvancedForm>
<AppointmentTemplate>
<div class="rsAptSubject">
<asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
<%# Eval("classType") %>
</div>
</AppointmentTemplate>
<TimeSlotContextMenuSettings EnableDefault="True"></TimeSlotContextMenuSettings>
<AppointmentContextMenuSettings EnableDefault="True"></AppointmentContextMenuSettings>
</telerik:RadScheduler>