Gantt chart SQL connection

[Adam Sarzynski]

I am trying to start the Gantt Chart control in conjunction with the SQL database. On the forum I found an example from 2017 but unfortunately it does not work properly - the task object is not added to the database and after manually added in the database there is a Javascript error in the browser. Is it possible to obtain the current example of combining this control (in version 17.1) with the database.

[Pooja Priya Krishna Moorthy]

Hi Adam, 

 

Greetings from Syncfusion support. 

 

We are prepared a Gantt sample and loaded tasks from SQL database and updated the database on CRUD action in source version 17.1.0.38. 

Please find the code example below. 

 

 

<ej:Gantt ID="Gantt1" runat="server" 

//… 

ActionComplete="ActionComplete"> 

</ej:Gantt> 

 

<asp:ScriptManager ID="ScriptManager" runat="server" EnablePageMethods="True" /> 

<script type="text/javascript">             

 

            function ActionComplete(args) { 

                if (args.requestType == "save" && args.addedRecord) { 

                    var data = args.addedRecord.item; 

                    PageMethods.AddIt(data); 

                } 

            } 

</script> 

 

 

 

[WebMethod] 

        public static void AddIt(TaskData record) 

        { 

            GanttSample sample = new GanttSample(); 

            sample.Add(record); 

 

        } 

 

       public void Add(TaskData Task) 

        { 

 

            GanttData data = new GanttData 

            { 

                TaskId = Task.TaskId, 

                //... 

            }; 

            db.GanttDatas.Add(data); 

            db.SaveChanges();         

        } 

         

 

Please, find the sample and KB link below. 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/Gantt_ASP.NET_Sample_EF1076300658 

KB: https://www.syncfusion.com/kb/8169/how-to-connect-and-update-changes-from-gantt-using-entity-framework 

 

Please get back to us if you require further assistance on this. 

 

Regards, 

Pooja Priya K.