Hotel Room Booking Tutorial 

The [Reservation] table stores the events (reservations).

CREATE TABLE [Reservation](
 [ReservationId] [int] IDENTITY(1,1) NOT NULL,
 [RoomId] [int] NOT NULL,
 [ReservationName] [nvarchar](100) NOT NULL,
 [ReservationPaid] [int] NOT NULL,
 [ReservationStatus] [int] NOT NULL,
 [ReservationStart] [datetime] NOT NULL,
 [ReservationEnd] [datetime] NOT NULL
);

The [Room] table stores the room details.

CREATE TABLE [Room](
 [RoomId] [int] IDENTITY(1,1) NOT NULL,
 [RoomName] [nvarchar](100) NOT NULL,
 [RoomStatus] [nvarchar](10) NOT NULL,
 [RoomSize] [int] NOT NULL
);


We will display the rooms on the vertical axis. First, we define the scheduler row header columns:
<DayPilot:DayPilotScheduler 
  ID="DayPilotScheduler1" 
  runat="server" 
  ...
  >
  <HeaderColumns>
      <DayPilot:RowHeaderColumn Title="Room" Width="80" />
      <DayPilot:RowHeaderColumn Title="Size" Width="80" />
      <DayPilot:RowHeaderColumn Title="Status" Width="80" />
  </HeaderColumns>
</DayPilot:DayPilotScheduler>

Then, we load the resources:

C#