I have an app wherein I store appointments in a DB.
I - normally - show the appointments in RadScheduler. However, there are occasions when using the scheduler is not the most appropriate too, for example, when the use queries the data base for a period covering more than 1 month.
In these cases, I use RadGrid to display the results of the query and this works just fine.
[wait for it]
But, I now have recurring appointments and these are stored using the recurrence rule in the master appointment. Is there a way for me to show the occurrences of these recurring appointments in a grid?
can think of doing it:
- Read the DB and set the DataSource of the Scheduler to the query result and then use the Scheduler's Appointments property as a DataSource for the grid.
- Read the DB and set the DataSource of the Scheduler to the query result and use the AppointmentDataBound event to create a new List<> to use as the DataSource of the grid.
I haven't yet tried either of these, 'cos I'm sure I've seen an demo, or Code Library article on this very subject, but I'll be damned if I can find it.
FWIW, I prefer the idea of the 2nd of the 2 options above as the AppointmentDataBound event gices me access to the DataItem used to create the appointment in the first place, can I have a lot of extra data in that object that I would, otherwise, have to query the DB again for.