How to get the itemsource from database to schedule view Horizontally

7 posts, 0 answers
  1. Manjuboyz
    Manjuboyz avatar
    9 posts
    Member since:
    Aug 2014

    Posted 29 Aug 2014 Link to this post

    Hi Yall

        I am trying one implementation of Schedule View, and I got exactly what i needed from demos :) but I need the data should from the database rather than used in XAML directly, Please check the below link , this is what I need except the Horizontal Values like "LiveCastNews","Voozy TV".... I need to have Employees list which should come from database itemsource, I am using silverlight.

    Please any help would be appreciated, I have used same demos code to implement and couldn't find resolution

    LINK

    http://demos.telerik.com/silverlight/#ScheduleView/FirstLook
  2. Yana
    Admin
    Yana avatar
    4554 posts

    Posted 29 Aug 2014 Link to this post

    Hello,

    If you need the appointments inside RadScheduleView to be loaded from a database, I would suggest that you check the Binding to Database tutorial in our documentation.

    If that's not the requirement, could you please describe it in more details?

    Regards,
    Yana
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
  3. DevCraft banner
  4. Manjuboyz
    Manjuboyz avatar
    9 posts
    Member since:
    Aug 2014

    Posted 29 Aug 2014 in reply to Yana Link to this post

    Thank you for your reply Yana

       Let me describe it, we already have a appointment page, now we wanted to change the appointment page to exactly same way as in demo, which I have give the link at the top, as in pic I have attached, you can see horizontal names i.e. "liveCastNews" "VoozyTv" and "SportixTV", instead of those name I need the employee names, I have a sql database where I have list of employees and their appointment schedules, so I want to bind that horizontal values to the employee names so that I can see the appointment is schedule to that time, Since I am working on Silverlight, But I don't have much Hands on experience on Schedule view appointment,

    My question is how can I access the values directly from sql database and show it on UI, Please let me know if you need any other information, if any any project is available that will help too
  5. Manjuboyz
    Manjuboyz avatar
    9 posts
    Member since:
    Aug 2014

    Posted 31 Aug 2014 in reply to Yana Link to this post

    Hi Yana

       You understood  my requirement ?? I asked for, please let me know if not.
  6. Yana
    Admin
    Yana avatar
    4554 posts

    Posted 01 Sep 2014 Link to this post

    Hello,

    These names are actually the Resources of the "TV" ResourceType, in the First Look example they're set directly in XAML, but you could set them in code-behind without a problem.  I would suggest that you take a look at the Resouces topic for detailed information on how to work with Resources inside RadScheduleView.

    It is up to you to decide how to retrieve the needed data for creating the Resources from the database - this is more of a general Silverlight question and I'd suggest that you check it at StackOverflow or MSDN Forums.

    If you have any additional questions regarding RadScheduleView functionality, we will be glad to help.

    Regards,
    Yana
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
  7. Manjuboyz
    Manjuboyz avatar
    9 posts
    Member since:
    Aug 2014

    Posted 02 Sep 2014 in reply to Yana Link to this post

    Hi

      Actually I did searched in Stackover flow about this question, to be honest I even posted a question there to get the information, still now I didn't got how to do it, it might be general question  but since it is first time I am using to get the value from database, I guess I might need help on this, I worked around the ResourceTypes and generated sample project with hardcoded values and getting as I desired(see Pic) as i said earlier it is hard coded values not from database.

    and here is the link from stack overflow which i have posted a question

    http://stackoverflow.com/questions/25599834/how-to-get-dynamic-values-in-telerik-scheduleviewresource
  8. Yana
    Admin
    Yana avatar
    4554 posts

    Posted 03 Sep 2014 Link to this post

    Hello,

    You could use, for example, a Silverlight-enabled WCF Service to get the data from the database, the approach is explained in this article. As soon as you receive the data in the Silverlight project you could add create the Resources to the corresponding ResourceType and set ResourceTypesSource of the ScheduleView.

    Regards,
    Yana
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
Back to Top
DevCraft banner