How about using SQL BETWEEN?
i.e.
WHERE (EventFrom BETWEEN @startDate and @endDate) OR (EventToBETWEEN @startDate and @endDate) )
What I'm not sure of, is how to update the Parameters of the ASP SQLdataSource I use to populate the DayPilotSchedule.
Any ideas?
SqlDataSourceEvents.SelectParameters["start"].DefaultValue = DateTime.Today.ToString("s");
<asp:ControlParameter Name="start" ControlID="DayPilotCalendar1" PropertyName="StartDate" />
Where would you put this?
Would it go everywhere you call DayPilotScheduler1.DataBind() ?
For example
Private Sub DayPilotScheduler1_Refresh(ByVal sender As Object, ByVal e As DayPilot.Web.Ui.Events.RefreshEventArgs) Handles DayPilotScheduler1.Refresh 'here? DayPilotScheduler1.DataBind() DayPilotScheduler1.Update() End Sub