DayPilot Forums

DayPilot is the best open-source Outlook-like calendar control for ASP.NET.
DayPilot Pro Demo (Calendar control)
» DayPilot Pro live demo (Calendar control)
DayPilot Pro Demo (Scheduler control)
» DayPilot Pro live demo (Scheduler control)
Home » How To » Do I need to filter out events outside datarange shown in DayPilotScheduler?

Do I need to filter out events outside datarange shown in DayPilotScheduler?

Hi,

I've got SQLdatasource as a source to a DayPilotScheduler. At the moment the Datasource returns all events.

Do I need to put in a WHERE statement on the Procedure the DS uses to just return bookings on the dates shown on the scheduler or does the Scheduler handle this?

If I have to do it, whats the best way to do it?

John - 6/27/2008 2:48:12 PM
You definitely should limit the result set. All the events are sent to the client during initial page loading and during subsequent CallBack (and PostBacks, of course). In addition, all the events are also stored in the ViewState unless you have turned it off for the control.

You should check the following topic:
http://forums.daypilot.org/Topic.aspx/208/daypilot_sql_sample_application
Dan Letecky - 6/27/2008 9:54:11 PM
Post reply