Data binding with more than one source.

2 posts, 0 answers
  1. Oliver
    Oliver avatar
    17 posts
    Member since:
    Aug 2008

    Posted 17 Oct 2012 Link to this post


    I have a database with two separate tables for different kinds of appointments; one for calls and tasks, and another for actual meetings.

    I want these all to be shown in the same RadScheduler, but as far as I can tell, it only takes one data source with one set of AppointmentMappingInfo (the two tables have some column names that differ).  How can I bind data from both tables into the same RadScheduler?

    Thank you!
  2. Ivan Todorov
    Ivan Todorov avatar
    688 posts

    Posted 19 Oct 2012 Link to this post


    Thank you for contacting us.

    RadScheduler does not support such binding scenario. To be able to load the data from the two tables in RadScheduler, you would need to create an additional layer which collects the data from both tables and presents it as a single table. This can be achieved by creating a view in your database which unites the two tables into one table with consistent fields (i.e. select the columns with different names that contain the same type of data as a single column). An alternative approach is to create programmatically a DataTable that contains the merged result of the two tables. Both cases will require some additional effort to implement the insert/update/delete operations which would not be needed if the data was in a single table.

    I hope you find this useful. Do not hesitate to write back in case you have any further questions.

    Ivan Todorov
    the Telerik team
    You’ve been asking for it and now it’s time for us to deliver. RadControls for WinForms Q3 2012 release is just around the corner. Sign up for a free webinar to see first all the latest enhancements.
Back to Top