Display Data from Database in Calendar

[Kashif]

Hi, i have been using the RadScheduler for a few Days. I want to Display Data from my Database in the Calendar.

My Table looks like that:

RoomName
Description
From-Date
Until-Date

I want to display these Data in the Calendar. I added a SqlDataSource and established an Connection to my Database. I tested the Query and it works. 

My Question is, how can i use this Data to Display the different Appointments in the Calendar. I only want to display them. No new Insert or Update.


Thanks in advcance

[Vijaianand]

You are almost there. You just need to link the datasource to the scheduler and it will show the appointment automatically.  Like
  DataKeyField="ID" DataSubjectField="Description" DataStartField="From-Date" DataEndField="Until-Date"
                    DataSourceID="SqlDatasourceID"


I also recommend you to check the demos at http://demos.telerik.com/aspnet-ajax/scheduler/examples/linqdatasource/defaultvb.aspx 

[Kashif]

Hi Vijaianand, thanks for your answer.

I already have that im my default.aspx:

<telerik:RadScheduler ID="RadScheduler1" runat="server" Culture="de-DE"

        DataEndField="UNTIL-DATE" DataKeyField="ID" DataSourceID="SqlDataSource1"

        DataStartField="FROM-DATE" DataSubjectField="DESCRIPTION" Height="">
</telerik:RadScheduler>

But it cant see any Appointments in the Calendar.. I dont know what iam doing wrong

[Vijaianand]

Do you have ID as the keyfield in your table? Check out the demo's you will get an idea? What error are you getting?