Bind Rad Scheduler To two Different Datasources

9 posts, 0 answers
  1. smith spd
    smith spd avatar
    89 posts
    Member since:
    May 2010

    Posted 04 Jun 2010 Link to this post

    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

  2. Veronica
    Admin
    Veronica avatar
    1213 posts

    Posted 09 Jun 2010 Link to this post

    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.

  3. smith spd
    smith spd avatar
    89 posts
    Member since:
    May 2010

    Posted 10 Jun 2010 Link to this post

    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

     

  4. smith spd
    smith spd avatar
    89 posts
    Member since:
    May 2010

    Posted 11 Jun 2010 Link to this post

    Hello Telerik team.

    kindly reply to my post.I am confused how to bind two data sources to a scheduler


    Thank you
    Smith
  5. Veronica
    Admin
    Veronica avatar
    1213 posts

    Posted 14 Jun 2010 Link to this post

    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.
  6. smith spd
    smith spd avatar
    89 posts
    Member since:
    May 2010

    Posted 15 Jun 2010 Link to this post

    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

     

  7. Veronica
    Admin
    Veronica avatar
    1213 posts

    Posted 16 Jun 2010 Link to this post

    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.
  8. smith spd
    smith spd avatar
    89 posts
    Member since:
    May 2010

    Posted 16 Jun 2010 Link to this post

    Hi,

    Please find it here
  9. roshani
    roshani avatar
    45 posts
    Member since:
    Dec 2010

    Posted 13 Jan 2011 Link to this post

    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
Back to Top