How to create database tables for ASPxScheduler?

Ned Sahin

10 years ago

DevExpress ASPxScheduler component requires you to create two tables for appointments and resources. The script below will create those tables for you. Then you will need to add them to SqlDataSources and associate them with ASPxScheduler.

CREATE TABLE [dbo].[resources](
     [ResourceID] [int] IDENTITY(1,1) NOT NULL,
     [Caption] [nvarchar](100) NULL,
     [Color] [nvarchar](100) NULL,
     [Image] [image] NULL
)

CREATE TABLE [dbo].[calendar](
     [ID] [int] IDENTITY(1,1) NOT NULL,
     [ResourceID] [int] NULL,
     [Status] [int] NULL,
     [Subject] [nvarchar](50) NULL,
     [Description] [ntext] NULL,
     [Label] [int] NULL,
     [StartTime] [datetime] NULL,
     [EndTime] [datetime] NULL,
     [Location] [nvarchar](50) NULL,
     [AllDay] [bit] NOT NULL,
     [EventType] [int] NULL,
     [RecurrenceInfo] [ntext] NULL,
     [ReminderInfo] [ntext] NULL
)