Codejock Developer Community : Populating Calendar http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 28 May 2026 18:51:24 +0000 Fri, 28 Aug 2009 11:10:03 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=15071 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Populating Calendar : Thanks again phainge... I will...]]> http://forum.codejock.com/forum_posts.asp?TID=15071&PID=52533&title=populating-calendar#52533 Author: johnp
Subject: 15071
Posted: 28 August 2009 at 11:10am

Thanks again phainge...  I will give that a try. Appreciate your quick response.]]> Fri, 28 Aug 2009 11:10:03 +0000 http://forum.codejock.com/forum_posts.asp?TID=15071&PID=52533&title=populating-calendar#52533 <![CDATA[Populating Calendar : johnp, When you call the Populate...]]> http://forum.codejock.com/forum_posts.asp?TID=15071&PID=52531&title=populating-calendar#52531 Author: phainge
Subject: 15071
Posted: 28 August 2009 at 10:59am

johnp,

When you call the Populate method, it will fire the The DoRetrieveDayEvents event for each day in the current view - this event is designed to read the appointments for just one day, so in order to be able to read the appointments for multiple days (i.e. the currently selected date range) you will need to put code in the calendar control SelectionChanged event to read all of the matching appointments (for the current date range) from the database into the recordset, then when you call the Populate method the code in the DoRetrieveDayEvents event will read just the appointments for that day from the recordset.  So it will be the SelectionChanged event that reads the appointments from the database, not the DoRetrieveDayEvents event.
 
Peter
]]> Fri, 28 Aug 2009 10:59:08 +0000 http://forum.codejock.com/forum_posts.asp?TID=15071&PID=52531&title=populating-calendar#52531 <![CDATA[Populating Calendar : phainge, thanks for the feedback....]]> http://forum.codejock.com/forum_posts.asp?TID=15071&PID=52527&title=populating-calendar#52527 Author: johnp
Subject: 15071
Posted: 28 August 2009 at 10:48am

phainge, thanks for the feedback. I am reading data into a recordset and using the recordset to populate the calendar control. I am sure that I am overlooking something obvious but, in my code I execute the following:

CalendarControl.Populate

This leads to a call to the following Private sub, once for each day shown (6 months worth) on the datepicker.

Private Sub m_pCalendar_DoRetrieveDayEvents(ByVal dtDay As Date, ByVal pEvents As xtremecalendarcontrol.CalendarEvents)

Are you suggesting that I set selection.begin and selection.end values to a single date so that this sub only gets called once and modify my recordset source statement to select the range of dates that I want?
]]> Fri, 28 Aug 2009 10:48:57 +0000 http://forum.codejock.com/forum_posts.asp?TID=15071&PID=52527&title=populating-calendar#52527 <![CDATA[Populating Calendar : Hi johnp, The calendar control...]]> http://forum.codejock.com/forum_posts.asp?TID=15071&PID=52523&title=populating-calendar#52523 Author: phainge
Subject: 15071
Posted: 28 August 2009 at 10:30am

Hi johnp,

The calendar control should only be reading appointments for the currently visible date range that aren't already cached.  The following properties expose the date range that is selected in the calendar control:

CalendarControl.ActiveView.Selection.Begin
CalendarControl.ActiveView.Selection.End
 
You can use the date range to read the matching appointments from the database into a recordset, and then have the calendar control populate itself from the recordset rather than the database.  That means each time the calendar view changes you are only performing one read from the database instead of multiple reads, which should speed things up.
 
Peter
]]> Fri, 28 Aug 2009 10:30:03 +0000 http://forum.codejock.com/forum_posts.asp?TID=15071&PID=52523&title=populating-calendar#52523 <![CDATA[Populating Calendar : I am having a real problem with...]]> http://forum.codejock.com/forum_posts.asp?TID=15071&PID=52519&title=populating-calendar#52519 Author: johnp
Subject: 15071
Posted: 28 August 2009 at 9:56am

I am having a real problem with speed on the calendar control. I am using data from an sql table with the custom data provider to get events. The calendar is making a separate call to the table for each day in the date picker. Is there not a way to make one call to the table and select all of the events at one time?]]> Fri, 28 Aug 2009 09:56:43 +0000 http://forum.codejock.com/forum_posts.asp?TID=15071&PID=52519&title=populating-calendar#52519