Bind To Data | ASP.NET Controls and MVC Extensions

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)

See also: Gantt Control

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

Task's ID.

ID

A task's parent ID.

ParentID

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.

PredecessorID

A successor task's ID.

SuccessorID

A dependency type.

DependencyType

A dependency ID.

ID
Resource (Resource)

Mandatory fields for a resource object:

Field description

Mapping

Task's resource ID.

ID

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.

ID

A task's resource ID.

ResourceID

A task's ID.

TaskID

Field description	Mapping
Task's ID.	ID
A task's parent ID.	ParentID
A task's title.	Title
A task's start date.	Start
A task's end date.	End

Field description	Mapping
A predecessor task's ID.	PredecessorID
A successor task's ID.	SuccessorID
A dependency type.	DependencyType
A dependency ID.	ID

Field description	Mapping
Task's resource ID.	ID
A task's resource name.	Name

Field description	Mapping
A task's resource assignment ID.	ID
A task's resource ID.	ResourceID
A task's ID.	TaskID

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 ID="ID" ParentID="ParentID" Title="Subject" Start="StartDate" End="EndDate" Progress="PercentComplete" />
        <Dependency ID="ID" PredecessorID="ParentID" SuccessorID="DependentID" DependencyType="Type" />
        <Resource ID="ID" Name="Name" />
        <ResourceAssignment ID="ID" TaskID="TaskID" ResourceID="TeamID" />
    </Mappings>
</dx:ASPxGantt>