This is a migrated thread and some comments may be shown as answers.

Display Data from Database in Calendar

3 Answers 137 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Kashif
Top achievements
Rank 1
Kashif asked on 09 Jul 2012, 02:42 PM
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

3 Answers, 1 is accepted

Sort by
0
Vijaianand
Top achievements
Rank 1
answered on 09 Jul 2012, 03:07 PM
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 
0
Kashif
Top achievements
Rank 1
answered on 09 Jul 2012, 06:29 PM
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
0
Vijaianand
Top achievements
Rank 1
answered on 09 Jul 2012, 06:54 PM
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?
Tags
Scheduler
Asked by
Kashif
Top achievements
Rank 1
Answers by
Vijaianand
Top achievements
Rank 1
Kashif
Top achievements
Rank 1
Share this question
or