All Products
Demos
Pricing
Services
Blogs
Docs & Support
Search
Shopping cart
Login
Contact Us
Get A Free Trial
close mobile menu
Telerik Forums
/
UI for ASP.NET AJAX Forum
/
Ajax
/
Unable to display datas from database in schedular
Cancel
Telerik UI for ASP.NET AJAX
Resources
Buy
Try
Feed for this thread
2 posts, 0 answers
Shi
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:
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>
222222.PNG
Shinu
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.
Thanks,
Shinu.
Back to Top
Close