http://tv.telerik.com/watch/radtips/episode/customizing-radscheduler-appointments-with-resources
Demo Appearance
Database Schema:
Sample Data:
dbo.Appointment
ID Subject Description Start End RecurrenceRule RecurrenceParentID Reminder Annotations TestResourceId
1 .NET User Group Meeting NULL 2011-11-14 12:00:00.000 2011-11-15 12:00:00.000 NULL NULL NULL NULL 1
2 Scrum Training !!! www 2011-11-30 12:00:00.000 2011-12-02 12:00:00.000 NULL NULL NULL NULL 1
3 Integration Partners Conference Call NULL 2011-11-22 12:00:00.000 2011-11-25 12:00:00.000 NULL NULL NULL NULL 2
4 DevConnect conference NULL 2011-11-11 12:00:00.000 2011-11-15 12:00:00.000 NULL NULL NULL NULL 2
5 DevMedia conference NULL 2011-11-01 06:30:00.000 2011-11-01 07:30:00.000 DTSTART:20111101T063000Z DTEND:20111101T073000Z RRULE:FREQ=DAILY;UNTIL=20111120T210000Z;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR EXDATE:20111116T063000Z NULL NULL NULL 3
7 DevMedia conference 2011-11-23 06:30:00.000 2011-11-23 07:30:00.000 5 NULL 3
9 yes 2011-12-06 00:00:00.000 2011-12-07 00:00:00.000 NULL BEGIN:VALARM TRIGGER:-PT10M X-TELERIK-UID:7998b08d-2595-4e14-8756-d988c8f8b6d9 END:VALARM NULL 1
10 yes 2011-11-21 00:00:00.000 2011-11-22 00:00:00.000 NULL BEGIN:VALARM TRIGGER:-PT5M X-TELERIK-UID:bb06f789-8fbb-4050-af24-4eab2b24d0dd END:VALARM NULL 2
dbo.TestResource
Id Description
1 resource A
2 resource B
3 resource C
4 resource D
5 resource E
Add RadScheduler Control And Config DataSource
Config RadScheduler Control Resource DataSource
Source Code:
<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeBehind="Default.aspx.cs" Inherits="telerikScheduler._Default" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2>
Welcome to ASP.NET!
</h2>
<p>
To learn more about ASP.NET visit <a href="http://www.asp.net" title="ASP.NET Website">www.asp.net</a>.
</p>
<p>
You can also find <a href="http://go.microsoft.com/fwlink/?LinkID=152368&clcid=0x409"
title="MSDN ASP.NET Docs">documentation on ASP.NET at MSDN</a>.
</p>
<telerik:RadScriptManager ID="RadScriptManager1" runat="server">
</telerik:RadScriptManager>
<telerik:RadScheduler ID="RadScheduler1" runat="server"
DataDescriptionField="Description" DataEndField="End" DataKeyField="ID"
DataRecurrenceField="RecurrenceRule"
DataRecurrenceParentKeyField="RecurrenceParentID" DataReminderField="Reminder"
DataSourceID="EntityDataSource1" DataStartField="Start"
DataSubjectField="Subject" EnableDescriptionField="True" Height=""
Reminders-Enabled="true">
<ResourceTypes>
<telerik:ResourceType DataSourceID="EntityDataSource2"
ForeignKeyField="TestResourceId" KeyField="Id" Name="Resource Type 0"
TextField="Description" />
</ResourceTypes>
<AdvancedForm Modal="true" />
<Reminders Enabled="true" />
<TimeSlotContextMenuSettings EnableDefault="true" />
<AppointmentContextMenuSettings EnableDefault="true" />
</telerik:RadScheduler>
<asp:EntityDataSource ID="EntityDataSource2" runat="server"
ConnectionString="name=IAppointmentEntities"
DefaultContainerName="IAppointmentEntities1" EnableFlattening="False"
EntitySetName="TestResources">
</asp:EntityDataSource>
<asp:EntityDataSource ID="EntityDataSource1" runat="server"
ConnectionString="name=IAppointmentEntities"
DefaultContainerName="IAppointmentEntities1" EnableDelete="True"
EnableInsert="True" EnableUpdate="True"
EntitySetName="Appointments">
</asp:EntityDataSource>
</asp:Content>