Bind To Data

• May 04, 2021
• 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.

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

Example:

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

• 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

• 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

Example:

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" />
        <Dependency Key="ID" PredecessorKey="ParentID" SuccessorKey="DependentID" DependencyType="Type" />
        <Resource Key="ID" Name="Name" />
        <ResourceAssignment Key="ID" TaskKey="TaskID" ResourceKey="TeamID" />
    </Mappings>
</dx:ASPxGantt>