Home » Development » How to create database tables for ASPxScheduler?

How to create database tables for ASPxScheduler?

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
)
It looks good!
It looks good!

Ned Sahin

Blogger for 20 years. Former Microsoft Engineer. Author of six books. I love creating helpful content and sharing with the world. Reach me out for any questions or feedback.

Leave a Comment