Event Loading

Load the data in the code behind using DataSource or DataSourceID properties.

Let's consider an event DB table with the following fields:

• id

• name

• start

• end

• resource

In order to show the events in the Scheduler you have to do the following steps:

1. Set the DataSource property

2. Map the column names.

3. Call DataBind().

1. DataSource

After loading a DataTable from a database (or other source) you should assign it to the DayPilotScheduler.DataSource property:

DayPilotScheduler1.DataSource = GetData(DayPilotScheduler1);

GetData() loads the data from a database:

public DataTable GetAssignments(DayPilotScheduler calendar)
{
  DataTable dt = new DataTable();
  SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [event] WHERE NOT (([end] <= @start) OR ([start] >= @end))", ConfigurationManager.ConnectionStrings["daypilot"].ConnectionString);
  da.SelectCommand.Parameters.AddWithValue("start", calendar.StartDate);
  da.SelectCommand.Parameters.AddWithValue("end", calendar.EndDate.AddDays(1));
  da.Fill(dt);
  return dt;
}

When loading the events from a database remember to limit the SELECT so only the necessary events are loaded.

See also

• How to use DayPilot Scheduler with LINQ to SQL

2. Map the Columns/Fields

You need to indicate which columns contain the necessary data:

DayPilotScheduler1.DataStartField = "start";
DayPilotScheduler1.DataEndField = "end";
DayPilotScheduler1.DataTextField = "name";
DayPilotScheduler1.DataIdField = "id";
DayPilotScheduler1.DataResourceField = "resource";

You can also set these properties in the visual designer:

3. DataBind()

Bind the data in the Page_Load() method:

protected void Page_Load(object sender, EventArgs e)
{
  if (!IsPostBack)
  {
    DayPilotScheduler1.DataSource = GetData(DayPilotScheduler1);

    DayPilotScheduler1.DataStartField = "start";
    DayPilotScheduler1.DataEndField = "end";
    DayPilotScheduler1.DataTextField = "name";
    DayPilotScheduler1.DataIdField = "id";
    DayPilotScheduler1.DataResourceField = "resource";

    DayPilotScheduler1.DataBind();
  }
}

4. Custom Event Data (Tags)

Define the data source fields that you want to pass with the event in DataTagFields, e.g. DataTagFields="eventtype, background".

There are three places where you can access the information from the tag fields:

1. BeforeEventRender event handler (access it as e.Tag["eventtype"] here and use it to draw custom icons in the event, custom background colors, etc.)

2. Event-related events on the client side, e.g. in EventClickJavaScript (as e.tag("eventtype")).

3. Event-related events on the server side, e.g. in EventClick event handler (as e.Tag["eventtype"]).

1. Load the data

Let's consider an event DB table with the following fields:

• id

• name

• start

• end

• resource

Load the event data and assign the result to Events property:

public class Dps : DayPilotScheduler
{
  protected override void OnInit(InitArgs initArgs)
  {
    Events = new EventManager().FilteredData(StartDate, StartDate.AddDays(Days)).AsEnumerable();
    // ...
  }
}

This is a sample EventManager class:

public class EventManager
{
  public DataTable FilteredData(DateTime start, DateTime end)
  {
    SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [event] WHERE NOT (([end] <= @start) OR ([start] >= @end))", ConfigurationManager.ConnectionStrings["daypilot"].ConnectionString);
    da.SelectCommand.Parameters.AddWithValue("start", start);
    da.SelectCommand.Parameters.AddWithValue("end", end);

    DataTable dt = new DataTable();
    da.Fill(dt);

    return dt;
  }
}

2. Map the Columns/Fields

public class Dps : DayPilotScheduler
{
  protected override void OnInit(InitArgs initArgs)
  {
    Events = new EventManager().FilteredData(StartDate, StartDate.AddDays(Days)).AsEnumerable();

    DataStartField = "start";
    DataEndField = "end";
    DataTextField = "name";
    DataIdField = "id";
    DataResourceField = "resource";

    // ...
  }
}

3. Update()

The OnInit() is invoked using a CallBack and it is necessary to ask the scheduler to redraw the event. You can do this by calling Update() or UpdateWithMessage(). 

public class Dps : DayPilotScheduler
{
     protected override void OnInit(InitArgs initArgs)
     {
         Events = new EventManager().FilteredData(StartDate, StartDate.AddDays(Days)).AsEnumerable();

         DataStartField = "start";
         DataEndField = "end";
         DataTextField = "name";
         DataIdField = "id";
         DataResourceField = "resource";
                
         UpdateWithMessage("Welcome!");
     }
}

4. Custom Event Data (Tags)

Define the data source fields that you want to pass with the event in DataTagFields, e.g. DataTagFields="eventtype, background".

There are three places where you can access the information from the tag fields:

1. OnBeforeEventRender event handler (access it as e.Tag["eventtype"] here and use it to draw custom icons in the event, custom background colors, etc.)

2. Event-related events on the client side, e.g. in the EventClickJavaScript (as e.tag("eventtype")).

3. Event-related events on the server side, e.g. in the OnEventClick event handler (as e.Tag["eventtype"]).