Hi,
I created the following table inside my database:
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 :
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...
I created the following table inside my database:
CREATE TABLE [Rooms]Then, I created a SQLdatasource to access the Appointments table. The connexion is succeful.
(
[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])
)
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.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...
In the Resource Type Collection Editor, add a new resource type and configure it to bind to the second SQLDataSource:
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...