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

[Solved] Recurrence Appts doesn't show up

1 Answer 121 Views

Scheduler

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

Alan Wang asked on 05 Nov 2009, 04:23 PM

I am using code behind to bind the dataset into scheduler and following is my code:

    
            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();

for some reason, the recurrence appointment does not show up on the scheduler, but non-recurrence appointment works just fine.
Following is the Recurrence Rule string:
DTSTART:20091207T080000Z
DTEND:20091207T083000Z
RRULE:FREQ=DAILY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR,SA,SU

And here is the table structure:

    
            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])

Please help me out here, I have been working on this issue for 3 days and so far no luck.

Thanks a lot
Alan

[Solved] Recurrence Appts doesn't show up

1 Answer, 1 is accepted