Trouble with DataSource binding

[Kechaoui]

Hello,

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]

Hi Kechaoui, 

 

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. 

UG: https://help.syncfusion.com/aspnet/schedule/data-binding#loading-data-on-demand 

Online Sample: http://asp.syncfusion.com/demos/web/schedule/loadondemand.aspx 

 

Regards, 

Karthigeyan 

[Kechaoui]

Hi,

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 ! 

Regards.

[Karthigeyan Krishnamurthi]

Hi Kechaoui, 

 

Thanks for your update. 

 

We have preapred the LOD CRUD sample using sql connection which can be download from the below location. 

http://www.syncfusion.com/downloads/support/forum/132875/ze/Sample-14837837 

 

Regards, 

Karthigeyan 

[Kechaoui]

Hi,

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 ?

Regards.

[Nevitha Ravi]

Hi Kechaoui, 

 

Thanks for your update. 

 

We have prepared a sample using UpdatePanel which can be downloaded from the below location. 

 

http://www.syncfusion.com/downloads/support/forum/132875/ze/schedule-2103802320 

<Code> 

<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server"> 

    <asp:UpdatePanel ID="UpdatePanel1" runat="server"> 

        <Triggers> 

            <asp:AsyncPostBackTrigger ControlID="Schedule1" /> 

        </Triggers> 

        <ContentTemplate> 

            <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" /> 

            </ej:Schedule> 

        </ContentTemplate> 

    </asp:UpdatePanel> 

</asp:Content> 

</Code> 

Regards, 

Nevitha.