Bind To Data

  • 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:

NOTE

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

Example:

<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

    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

    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

Example:

<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>