This is a migrated thread and some comments may be shown as answers.

Schedular with a database

0 Answers 62 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Max
Top achievements
Rank 1
Max asked on 01 Oct 2008, 02:51 PM
Hi,

I created the following table inside my database:

CREATE TABLE [Rooms]
(
   [ID]        INT                IDENTITY(1,1)   NOT NULL,
   [RoomName]  nvarchar(255)                    NOT NULL,
   CONSTRAINT [PK_Rooms] PRIMARY KEY CLUSTERED
   ([ID])
)
GO
CREATE TABLE [Users]
(
   [ID]        INT                NOT NULL,
   [UserName]  nvarchar(255)      NOT NULL,

   CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
   ([ID])
)
GO

CREATE TABLE [dbo].[Appointments] 

   [ID]                    INT IDENTITY(1,1)   NOT NULL, 
   [Subject]               nvarchar(255)       NOT NULL, 
   [Start]                 datetime            NOT NULL, 
   [End]                   datetime            NOT NULL,
   [RoomID]                INT                 NULL,
   [UserID]                INT                 NULL,
   [RecurrenceRule]        nvarchar(1024)      NULL, 
   [RecurrenceParentID]    INT                 NULL, 
   [Annotations]           nvarchar(50)        NULL, 

   CONSTRAINT [PK_Appointments] PRIMARY KEY CLUSTERED  
       ([ID]), 

   CONSTRAINT [FK_Appointments_ParentAppointments] FOREIGN KEY 
       ([RecurrenceParentID]) 
   REFERENCES 
       [Appointments] ([ID]),

   CONSTRAINT [FK_Appointments_Rooms] FOREIGN KEY 
       ([RoomID]) 
   REFERENCES 
       [Rooms] ([ID]),

   CONSTRAINT [FK_Appointments_Users] FOREIGN KEY 
       ([UserID]) 
   REFERENCES 
       [Users] ([ID]) 
Then, I created a SQLdatasource to access the Appointments table. The connexion is succeful.
In the smart tag of the controler, I defined the correct field for key, start time, end time, ect...

I also created a second SQLdatasource to access the Users table.

Then I did this :

Select the RadScheduler in the designer, and click the ellipsis button on the ResourceTypes property in the property pane.
In the Resource Type Collection Editor, add a new resource type and configure it to bind to the second SQLDataSource:
Problem is: I can't add any events in the scheduler. When I double click on the scheduler, I see the box to create a new event, but when i click on the icon to create the event, it just disappear...

What have I done wrong ?

Thx a lot for your help

Edited:
I didn't check the box generate update insert delete while creating the datasource...

No answers yet. Maybe you can help?

Tags
Scheduler
Asked by
Max
Top achievements
Rank 1
Share this question
or