calendar to bind to custom sql on refresh

The refreshCallBack() client-side function translates the parameters into a new StartDate and Days (if supplied) and send it together with your own custom data (which will contain the filter information in your case) to the server. On the server side, Refresh event is called.

So in order to update the bound data set you should handle Refresh event and rebind there. You can take a look at this documentation page (it's for DayPilotSchedulerDynamic but in DayPilotCalendar it works the same way):

www.daypilot.org/daypilotschedulerdynamic-fast-refresh-refreshcallback.html

Just a note, in DayPilot Pro 5.1 there will be a new event introduced (Command) that is a more generic replacement for refresh (it simply sends your custom data structure to the server). See also the DayPilotScheduler documentation for Command (it's already implemented for DPS):

www.daypilot.org/daypilotscheduler-commandcallback-function-universal-callback.html

Please let me know if it didn't help.

The documentation for refreshcallback seem to indicated that you can only send a date or integer value. I need to send a number of other parameters. I don't suppose you would have a working example of a daypilot with some customized sql? I have spent a lot of time and am about to give up.

Thank you.

The refreshCallBack function has three parameters:

dpc.refreshCallBack = function(date, days, data)

The third parameter is a string that can hold any custom value. In version 5.1 it will accept any object (that will be accessible as JsonData object on the server side).

In the server-side Refresh event handler, you can load the dataset using custom SQL without problems. It can look like this (a simplified example):

SqlDataAdapter da = new SqlDataAdapter("SELECT id, name, start, end FROM events WHERE filter = @filter", "connection string");
da.SelectCommand.Parameters.Add("filter", e.Data);
// ... add other parameters
DataTable dt = new DataTable();
da.Fill(dt);

DayPilotCalendar1.DataSource = dt;
DayPilotCalendar1.DataBid();

If it's still not clear, please contact me at support@daypilot.org.

Dan,

I triedadding a session variable (which containsthe added data that is neededfor a custom sql call) into the refreshcallback function (see below), but itends up giving me a error in the server side event handler saying that the string isnot in theneeded datetime format.I really like the calendar, butit seems that thiscould be easier. Icould really use a working example

protected void Calendar1_DayRender(object sender, System.Web.UI.WebControls.DayRenderEventArgs e)
{
e.Cell.Text = "<a href=\"javascript:dpc1.refreshCallBack(new Date('" + DayPilot.Utils.JsDate.FormatDateTime(e.Day.Date) + ",," + Session["m"] + "'))\">" + e.Day.DayNumberText + "</a>";
}

I also tried putting single quotes around each of the parameters ....

protected void Calendar1_DayRender(object sender, System.Web.UI.WebControls.DayRenderEventArgs e)
{
e.Cell.Text = "<a href=\"javascript:dpc1.refreshCallBack(new Date('" + DayPilot.Utils.JsDate.FormatDateTime(e.Day.Date) + "','','" + Session["m"] + "'))\">" + e.Day.DayNumberText + "</a>";
}