Thank you for writing.
To get the appointments without using RadScheduler
you should first setup a SchedulerBindingDataSource
which is the component used when binding RadScheduler
. You can find out how to achieve this in the following help article: Data Binding Walkthrough
Then you can simply call the GetItems
method of the EventProvider
to get the appointments:
List<IEvent> appointments =
As to your second question, recurrences are stored as string rules in the database and each occurrence is auto generated according to that rule. Therefore, you cannot do a query directly over your SQL table but you should first load the appointments as shown above and then check each of them along with their occurrences. This is demonstrated below:
List<IEvent> GetAppointmentsAfterDate(DateTime targetDate, List<IEvent> sourceList)
List<IEvent> result =
(appointment.Start >= targetDate)
OccurrenceEnumerator enumerator =
(enumerator.MoveNext() && enumerator.Current !=
I hope you find this useful. Let me know if you need anything else.
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WINFORMS.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>