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:
See also: Gantt Control
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
|
Dependency (Dependency)
Mandatory fields for a dependency object:
Resource (Resource)
Mandatory fields for a resource object:
Field description
| Mapping
|
---|
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:
<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>