We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Use the same table data in gantt & schedule

I have a really complicated problem. I want the same tasks to be present in the schedule & gantt controls (read, add, delete, modify from schedule and gantt should be possible).
The schedule works before I change the task table (in sql database), But now he does not show me anything in the schedule either the gantt control. 
Then if it is possible to add more attributes (Status, Priority) to task and show the kanbanboard.
Help me please.
The tasks table:

CREATE TABLE [dbo].[Tasks] (
    [TaskID]              INT            IDENTITY (1, 1) NOT NULL,
    [Title]               NCHAR (50)     NOT NULL,
    [Description]         NCHAR (50)     NULL,
    [Start]               DATETIME       NOT NULL,
    [StartTimezone]       NCHAR (50)     NULL,
    [End]                 DATETIME       NOT NULL,
    [EndTimezone]         NCHAR (50)     NULL,
    [RecurrenceRule]      NCHAR (50)     NULL,
    [RecurrenceID]        INT            NULL,
    [RecurrenceException] NCHAR (50)     NULL,
    [IsAllDay]            BIT            NULL,
    [OwnerID]             INT            NULL,
    [Duration]     INT  NULL,
    [ParentID]            INT            NULL,
    [ProjectID]            INT            NOT NULL,
    [Progress]            INT            NULL,
    [Predecessors]             NCHAR (50)            NULL,
   
    PRIMARY KEY CLUSTERED ([TaskID] ASC)
);

My tasks Model class:

 public partial class Tasks
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int TaskID { get; set; }
        [Required]
        [StringLength(50)]
        public string Title { get; set; }
        [StringLength(50)]
        public string Description { get; set; }
        public DateTime Start { get; set; }
        public string StartTimezone { get; set; }
        public DateTime End { get; set; }
        public string EndTimezone { get; set; }
        [StringLength(50)]
        public string RecurrenceRule { get; set; }
        public int RecurrenceID { get; set; }
        [StringLength(50)]
        public string RecurrenceException { get; set; }
        public bool IsAllDay { get; set; }
        public int OwnerID { get; set; }
        public int Duration { get; set; }
        public int Progress { get; set; }
        public int ParentID { get; set; }
       public int ProjectID { get; set; }
        public string Predecessors { get; set; }
        public List<int> ResourceID { get; set; }
    }



1 Reply

MK Mahalakshmi Karthikeyan Syncfusion Team November 18, 2016 12:01 PM UTC

Hi Anis, 
Thanks for contacting Syncfusion support. 
As we are working on the requested custom sample, a support incident has been created under your account for better follow up. Please log on to our support website to check for further updates. 
Regards, 
Mahalakshmi K. 


Loader.
Live Chat Icon For mobile
Up arrow icon