devexpress-examples / how-to-enhance-performance-when-handling-a-large-number-of-appointments-e489

Dynamically limit the number of appointments loaded into the scheduler storage.

Scheduler for ASP.NET Web Forms - How to enhance scheduler performance when handling a large number of appointments

This example demonstrates how to handle the FetchAppointments event to dynamically limit the number of appointments loaded into the scheduler storage. This approach can be useful when a scheduler contains a large amount of data, and only a small part of it needs to be loaded at one time.

protected void ASPxScheduler1_FetchAppointments(object sender, DevExpress.XtraScheduler.FetchAppointmentsEventArgs e) {
    SetAppointmentDataSourceSelectCommandParameters(e.Interval);
    e.ForceReloadAppointments = true;
}
protected void SetAppointmentDataSourceSelectCommandParameters(TimeInterval interval) {
    SqlDataSource1.SelectParameters["OriginalOccurrenceStart"].DefaultValue = interval.Start.ToString();
    SqlDataSource1.SelectParameters["OriginalOccurrenceEnd"].DefaultValue = interval.End.ToString();
}

Files to Review

• Default.aspx (VB: Default.aspx)
• Default.aspx.cs (VB: Default.aspx.vb)

Documentation

• FetchAppointments Event - Handling Large Datasets

More Examples

• Scheduler for ASP.NET MVC - - How to implement the FetchAppointment delegate method