or

<
td> style="height: 50px; width: 614px;">
<telerik:RadTextBox ID="Objet" runat="server" Width="640px" Skin="Office2007" EnableViewState="False" />



| string sql = "select * from Appts where userid=@userid"; |
| QueryCommand cmd = new QueryCommand(sql); |
| int userId = Convert.ToInt32(userDS.Tables[0].Rows[0]["ID"].ToString()); |
| cmd.AddParameter("@userid", userId, DbType.Int32); |
| DataSet ds = DataService.GetDataSet(cmd); |
| schedulerAppt.DataKeyField = "ID"; |
| schedulerAppt.DataStartField = "Start"; |
| schedulerAppt.DataEndField = "End"; |
| schedulerAppt.DataSubjectField = "Subject"; |
| schedulerAppt.Attributes["Description"] = "Description"; |
| schedulerAppt.Attributes["CaseId"] = "CaseId"; |
| schedulerAppt.Attributes["TypeId"] = "TypeId"; |
| schedulerAppt.DataRecurrenceField = "RecurrenceRule"; |
| schedulerAppt.DataRecurrenceParentKeyField = "RecurrenceParentID"; |
| schedulerAppt.DataSource = ds; |
| schedulerAppt.Rebind(); |
| CREATE TABLE [dbo].[Appts]( |
| [ID] [int] IDENTITY(1,1) NOT NULL, |
| [CaseId] [int] NOT NULL, |
| [UserId] [int] NOT NULL, |
| [TypeId] [int] NOT NULL, |
| [Subject] [nvarchar](255) NOT NULL, |
| [Description] [nvarchar](255) NOT NULL, |
| [Start] [datetime] NOT NULL, |
| [End] [datetime] NOT NULL, |
| [RecurrenceRule] [nvarchar](1024) NULL, |
| [RecurrenceParentID] [int] NULL, |
| CONSTRAINT [PK_Appointments] PRIMARY KEY CLUSTERED |
| ( |
| [ID] ASC |
| )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
| ) ON [PRIMARY] |
| GO |
| ALTER TABLE [dbo].[Appts] WITH CHECK ADD CONSTRAINT [FK_Appointments_ParentAppointments] FOREIGN KEY([RecurrenceParentID]) |
| REFERENCES [dbo].[Appts] ([ID]) |