We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Trouble with DataSource binding

Thread ID:





132875 Sep 26,2017 01:23 PM UTC Oct 3,2017 12:16 PM UTC ASP.NET Web Forms 5
Tags: Schedule
Asked On September 26, 2017 01:25 PM UTC


It's possible to change my datasource when I clicked on differents views ('Day', 'Week', 'Month') ?

for example:

 when I'll click on the day view, my datasource must be like this

 <asp:SqlDataSource ID="SqlData" runat="server" ConnectionString="<%$ ConnectionStrings:ScheduleConnectionString %>"
            SelectCommand="SELECT * FROM [Appointment] WHERE date_appointments ='26/09/2017' ">asp:SqlDataSource>
  •  Week view binding
<asp:SqlDataSource ID="SqlData" runat="server" ConnectionString="<%$ ConnectionStrings:ScheduleConnectionString %>"
            SelectCommand="SELECT * FROM [Appointment] WHERE date_appointments >='26/09/2017' AND  date_appointments<='03/10/2017'">asp:SqlDataSource

Because, I can't use a global  datasource (like refer  there), when I've a table with +100000rows.

Best regards.

Karthigeyan Krishnamurthi [Syncfusion]
Replied On September 27, 2017 04:27 AM UTC

Thank you for contacting Syncfusion support. 
Load on demand feature allows the Scheduler to retrieve only the filtered appointment data (for the current Scheduler date range and current view) from the service/database during both initial rendering and navigating the views. Kindly vist the below links to know more about the Load on demand feature. 

Replied On September 28, 2017 09:53 AM UTC


Thanks for those links, can I've an example with SqlDataSource please ?

Because in the sample it's with a List of ScheduleAppointmentsObjData, and in my case I need to fill my schedule with appointment from a sqlserver DB,  .

So, can I've an example combining LoadOnDemand and SqlDataSource ,   it would be perfect ! 


Karthigeyan Krishnamurthi [Syncfusion]
Replied On September 29, 2017 07:08 AM UTC

Hi Kechaoui, 
Thanks for your update. 
We have preapred the LOD CRUD sample using sql connection which can be download from the below location. 

Replied On October 2, 2017 02:32 PM UTC


Thanks a lot for your answers ! It was very helpful.

However, I got a last question, It is possible to use partial postback  ?  Usually, I used updatePanel for it, but he doesn't seems to works with ej:Schedule, do you have an alternative ?


Nevitha Ravi [Syncfusion]
Replied On October 3, 2017 12:16 PM UTC

Hi Kechaoui, 
Thanks for your update. 
We have prepared a sample using UpdatePanel which can be downloaded from the below location. 

<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server"> 
    <asp:UpdatePanel ID="UpdatePanel1" runat="server"> 
            <asp:AsyncPostBackTrigger ControlID="Schedule1" /> 
            <ej:Schedule ID="Schedule1" ClientIDMode="Static" Height="525px" EnableLoadOnDemand="true" Width="100%" CurrentDate="5/5/2014" runat="server"> 
                <AppointmentSettings ApplyTimeOffset="false" Id="Id" Subject="Subject" AllDay="AllDay" StartTime="StartTime" EndTime="EndTime" Recurrence="Recurrence" RecurrenceRule="RecurrenceRule" /> 
                <DataManager CrossDomain="true" URL="Default.aspx/GetData" CrudURL="Default.aspx/CrudResult" InsertURL="Default.aspx/InsertData" UpdateURL="Default.aspx/UpdateData" RemoveURL="Default.aspx/RemoveData" Adaptor="UrlAdaptor" /> 



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon