Home / Community & Support / Developer Productivity Tools Forums / SharePoint 2007 > Integrating Controls > Bind Rad Scheduler To two Different Datasources

• smith spd Intermediate

  Posted on Jun 4, 2010 (permalink)

  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

  http://www.telerik.com/help/aspnet-ajax/schedule_databindingimplementingaproviderthatsupportsmultivaluedresources.html

  Any sample for this is greatly appreciated.

  Thank you,
  Smith

  Reply

• Veronica Veronica

  Posted on Jun 9, 2010 (permalink)

  Hi Smith,
  
  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.

  Attached files

  • schedulerboundtotwodatasources.zip

  Reply


• smith spd Intermediate

  Posted on Jun 10, 2010 (permalink)

  Hello Telerik Team,
  
  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

   

  Reply

• smith spd Intermediate

  Posted on Jun 11, 2010 (permalink)

  Hello Telerik team.
  
  kindly reply to my post.I am confused how to bind two data sources to a scheduler
  
  
  Thank you
  Smith

  Reply

• Veronica Veronica

  Posted on Jun 14, 2010 (permalink)

  Hi smith spd,
  
  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.

  Reply

• smith spd Intermediate

  Posted on Jun 15, 2010 (permalink)

  Hello Telerik team,
  
  

  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

   

  Reply

• Veronica Veronica

  Posted on Jun 16, 2010 (permalink)

  Hi 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.

  Reply

• smith spd Intermediate

  Posted on Jun 16, 2010 (permalink)

  Hi,
  
  Please find it here

  Reply

• roshani

  Posted on Jan 13, 2011 (permalink)

  Hello,
  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

  Reply

Back to Top

Home / Community & Support / Developer Productivity Tools Forums / SharePoint 2007 > Integrating Controls > Bind Rad Scheduler To two Different Datasources