Unable to display datas from database in schedular

2 posts, 0 answers
  1. Shi
    Shi avatar
    1 posts
    Member since:
    Jul 2013

    Posted 14 Jul 2013 Link to this post

    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:
    <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">
        <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" 
             <AdvancedForm Modal="True" EnableCustomAttributeEditing="True"></AdvancedForm>                
                        <div class="rsAptSubject">
                            <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
                             <%# Eval("classType") %>
                 <TimeSlotContextMenuSettings EnableDefault="True"></TimeSlotContextMenuSettings>
                <AppointmentContextMenuSettings EnableDefault="True"></AppointmentContextMenuSettings>
  2. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 15 Jul 2013 Link to this post

    Hi Shi,

    Please have a look at this code library project which deals with binding RadScheduler using an ASP SQL data source.

Back to Top