Hello Telerik Team,
I have a requirement where i need to bind the Radscheduler to two datasources.Meaning
I have developed a usercontrol which is wrapped in a Sharepoint webpart which consists of a
rad scheduler.As of now my rad scheduler pulls the information from a specific list.
But now i need to pull the information for the appointments not only from a specific list but also from a sql database table.
what is the method i need to follow.
Do i need to use this
Any sample for this is greatly appreciated.
Thank you,
Smith
8 Answers, 1 is accepted
In the attached .zip file you may find a sample project which shows how to bind the RadScheduler to two datasources. We have a class called AppointmentInfo which contains the needed information about an appointment. We also have two generic lists called Appointments1 and Appointments2 which keep different data. They play the role of the two datasources which will bind the RadScheduler. The Scheduler is bound finally by a third list called Appointments.
We use a custom attribute to keep track of where the appointment is coming from so we can update the respective data source on Update/Delete operations.
Find the full code in the attached .zip file.
Hope this helps.
Regards,
Veronica Milcheva
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Rank 1
Thank you for the sample.But in this case you are attaching two lists as two different datasources to the rad scheduler but Is there a way to connect both sql data source and list as a data source.Because the DataStartField,DataEndField ,DataSubjectField ,DataKeyField have to be unique for both datasources.I am confused with this.
Is there any sample which demonstrates the same.Please kindly let me know.
Thank you
Smith
Rank 1
kindly reply to my post.I am confused how to bind two data sources to a scheduler
Thank you
Smith
All ASP.NET data-bound controls support only a single data source. RadScheduler is no exception and the only option to aggregate data from multiple sources is to do it manually, as in the provided example.
All the best,
Veronica Milcheva
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Rank 1
I some how managed to show the appointments from List as well as sql database table on the scheduler.
I am able to see the default columns like id,subject,start,end on the shceduler for all the appointments
populating from sql table(if a it is a sql item) or list(if it is a list item).
I have used databinding in the appointment template to show these default columns.
But now i need to show the additional columns which should be populated on the appointment template.
And another thing is i need to bind the same data into the edit appointment template.
I appreciate your response and your direction.
Thank you
Smith
In order to progress with the investigation of the problem set forth, you can consider sending us the problematic code, in the form of a small working project, which we can review locally. As soon as we do, we will get back to you with more information on the matter.
Thank you!
Regards,
Veronica Milcheva
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Rank 1
I have implemented radscheduler but facing a problem with it now. I have posted all the details in this forum. Please provide some reply. Its urgent.
Thanks in advance,
Roshani