SQL Database

We prepared a sample example how to populate the RadGanttView with a data from a SqlServer. In the attached zip file you can find the project plus db schema and backup which will restore the database with a sample data. Also, the connection string must be modified for the correct server name.

Please, note that the GanttView is still in CTP version and there could be some breaking changes with the official release, but they will be documented and the project will be modified. The attached sample works with the official Q1 SP1 assemblies.

Hope this helps.

Please, double check the connection string in the project. It must match the correct server and database.

Title,Description

dbo.SqlTasks

Please, double check whether the database contains any records. Moreover, check the VisibleRange of the GanttView and if there are any tasks what are visible in the ranged.

With the Q2 release we introduced some breaking changes for the control which could cause the issues you faced with. Please, refer to our online documentation for more information about RadGanttView backward compatibility - http://www.telerik.com/help/silverlight/radganttview-backward-compatibility.html 

Hope this helps.

I really would appreciate your help, on this matter.

I’m facing a new problem link to dependency between tasks. Prior to be saved all new tasks added have the same id = 0. If I add 3 new tasks in a row with dependency between them, then only the first task added will keep its dependency.

The work around is to save automatically after adding a new task and after all manipulation in the UI. I tried to implement the events ManipulationCompleted, ManipulationDelta, ManipulationStarted, I got the error message: Failed to assign to property 'System.Windows.UIElement.ManipulationCompleted'.

Best regards

Sebastien

Hi Kalin,

I'm coming back to the forum with a new question regarding import from Microsoft Project. We would like to have the possibility to import directly from Microsoft Project tasks into our Sql database. On Telerik demo website there is this example :

http://demos.telerik.com/silverlight/#GanttView/Import

This example show a method that convert XML from MSProject  into a task list that is an ObservableCollection<GanttTask>();

Would you have a method to convert XML from MSProject into an ObservableCollection<SqlTask> or would you have a method to convert GanttTask into SqlTask ?

Best regards

Sebastien

Hello Polya,

Thanks for the very quick reply. We will have a look at this solution.

Best regards

Sebastien

Hello Polya, my name is Leonel, I'm working with Sebastien in the same project.

Sometimes when I change dates or add a child task (for example), silverlight exception are thrown, (see attached file), how can I debug that to see errors?

Seems like there is not too much info over the Net regarding Gantt and SQL. In my case a have a tree column (should be task and sub task) but how do I set bind them to SQL table? There's only option to set binding for tree column.

<telerik:RadGanttView.Columns><telerik:TreeColumnDefinition MemberBinding="{Binding TaskId}" Header="Tasks" IsFrozenColumn="True"/><telerik:ColumnDefinition MemberBinding="{Binding StartTime}" Header="Start" /><telerik:ColumnDefinition MemberBinding="{Binding EndTime}" Header="End" /></telerik:RadGanttView.Columns>

Can someone please upload working WPF project.