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!

Port135

Blogger for 20 years. I love creating helpful content and sharing with the world. Reach me out for any questions or feedback.

Leave a Comment