I need to be able to display different colors in the Calendar's Cell's for different values that may be stored in my table named WellnessChoice_PhysicalActivityLog in my DB. From what I read it appears that I need to use the Day_Render Event but I have never used the Calendar Control and not sure how to tie this together.
For Example, below is an actuall example of the data in my WellnessChoice_PhysicalActivityLog Table. I need to be able to display a different Calendar Cell for each different palv_id. So if for example the palv_id = 4 then display that Cell Color Blue, if palv_id = 7 then display that Cell Color Red. etc....
pal_id palv_id pi_id pal_date
4000 4 1277 2011-08-08 00:00:00.000
4001 7 1277 2011-08-12 00:00:00.000
4002 8 1277 2011-08-23 00:00:00.000
4003 9 1277 2011-08-29 00:00:00.000