Bind Gantt To Data

• Dec 23, 2022
• 2 minutes to read

The Gantt control can operate only in bound mode. It supports standard data source types including SqlDataSource, ObjectDataSource, XmlDataSource, AccessDataSource, and SiteMapDataSource.

Run Demo: ASPxGantt - Data Binding and Editing

Data Source

The Gantt control requires a separate data source for each of the following objects:

• Tasks (TasksDataSourceID)
• Dependencies (DependenciesDataSourceID)
• Resources (ResourcesDataSourceID)
• Resource Assignments (ResourceAssignmentsDataSourceID)

Note

Refer to the following topics to learn how to generate sample data for the Gantt (SQL script and C# code):

• Microsoft SQL Server
• Custom Objects Collection

ASPX

<dx:ASPxGantt ID="Gantt" runat="server" Width="100%" ClientInstanceName="clientGantt"
    KeyFieldName="ID" ParentFieldName="ParentID" 
    TasksDataSourceID="TasksDataSource" 
    DependenciesDataSourceID="DependenciesDataSource" 
    ResourcesDataSourceID="ResourcesDataSource" 
    ResourceAssignmentsDataSourceID="ResourceAssignmentsDataSource">
    ...
</dx:ASPxGantt>

<asp:SqlDataSource ID="TasksDataSource" runat="server" 
ConnectionString='<%$ ConnectionStrings:DevelopmentGanttConnectionString %>' 
SelectCommand="SELECT * FROM [Tasks]" />

<asp:SqlDataSource ID="DependenciesDataSource" runat="server" 
ConnectionString='<%$ ConnectionStrings:DevelopmentGanttConnectionString %>' 
SelectCommand="SELECT * FROM [TaskDependecies]" />

<asp:SqlDataSource ID="ResourcesDataSource" runat="server" 
ConnectionString='<%$ ConnectionStrings:DevelopmentGanttConnectionString %>' 
SelectCommand="SELECT * FROM [Teams]" />

<asp:SqlDataSource ID="ResourceAssignmentsDataSource" runat="server" 
ConnectionString='<%$ ConnectionStrings:DevelopmentGanttConnectionString %>' 
SelectCommand="SELECT * FROM [TaskTeamRelations]" />

Mappings

Mappings specify which field in a data source corresponds to an object’s property (task, dependency, resource).

The Gantt control requires mappings for the following objects:

• Task (Task)

  Mandatory fields for a task object:

  Field description	Mapping
  A task’s ID.	Key
  A task’s parent ID.	ParentKey
  A task’s title.	Title
  A task’s start date.	Start
  A task’s end date.	End
  A task’s color.	Color

• Dependency (Dependency)

  Mandatory fields for a dependency object:

  Field description	Mapping
  A predecessor task’s ID.	PredecessorKey
  A successor task’s ID.	SuccessorKey
  A dependency type.	DependencyType
  A dependency ID.	Key

• Resource (Resource)

  Mandatory fields for a resource object:

  Field description	Mapping
  A task’s resource ID.	Key
  A task’s resource name.	Name
  A task resource’s color.	Color

• Resource Assignment (ResourceAssignment)

  Mandatory fields for a resource assignment object:

  Field description	Mapping
  A task’s resource assignment ID.	Key
  A task’s resource ID.	ResourceKey
  A task’s ID.	TaskKey

ASPX

<dx:ASPxGantt ID="Gantt" runat="server" Width="100%" ClientInstanceName="clientGantt"
    KeyFieldName="ID" ParentFieldName="ParentID" 
    TasksDataSourceID="TasksDataSource" 
    DependenciesDataSourceID="DependenciesDataSource" 
    ResourcesDataSourceID="ResourcesDataSource" 
    ResourceAssignmentsDataSourceID="ResourceAssignmentsDataSource">
    <Columns>
    ...
    </Columns>
    <Mappings>
        <Task Key="ID" ParentKey="ParentID" Title="Subject" Start="StartDate" End="EndDate" Progress="PercentComplete" Color="Color" />
        <Dependency Key="ID" PredecessorKey="ParentID" SuccessorKey="DependentID" DependencyType="Type" />
        <Resource Key="ID" Name="Name" Color="Color" />
        <ResourceAssignment Key="ID" TaskKey="TaskID" ResourceKey="TeamID" />
    </Mappings>
</dx:ASPxGantt>

Limitation

• The ASPxGantt control displays the progress of the task in integer format even if it is in decimal format in the data source.