How to get the itemsource from database to schedule view Horizontally

[Manjuboyz]

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

[Yana]

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

 

 

[Manjuboyz]

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

[Manjuboyz]

Hi Yana

   You understood  my requirement ?? I asked for, please let me know if not.

[Yana]

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

 

 

[Manjuboyz]

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

[Yana]

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