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

Unable to display datas from database in schedular

1 Answer 55 Views
Ajax
This is a migrated thread and some comments may be shown as answers.
Shi
Top achievements
Rank 1
Shi asked on 14 Jul 2013, 02:24 PM
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>

1 Answer, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 2
answered on 15 Jul 2013, 06:12 AM
Hi Shi,

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

Thanks,
Shinu.
Tags
Ajax
Asked by
Shi
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
Share this question
or