データ連結

.NET 6
.NET Framework

This section walks you through the process for achieving data binding in GanttView for .NET 6 framework.

Add Task to the GanttView control and set its properties.

C#	コードのコピー
//タスクを追加し、プロパティを設定します。 var task1 = c1GanttView1.Tasks[1]; task1.ConstraintDate = new System.DateTime(2012, 6, 22, 0, 0, 0, 0); task1.ConstraintType = C1.Win.GanttView.ConstraintType.StartNoEarlierThan; task1.Duration = 3; task1.ID = 656460240; task1.Mode = C1.Win.GanttView.TaskMode.Automatic; task1.Name = "Pursue a hare"; task1.Start = new System.DateTime(2015, 4, 1, 0, 0, 0, 0); var task2 = c1GanttView1.Tasks[2]; task2.ConstraintDate = new System.DateTime(2012, 6, 26, 0, 0, 0, 0); task2.ConstraintType = C1.Win.GanttView.ConstraintType.StartNoEarlierThan; task2.Duration = 12; task2.DurationUnits = C1.Win.GanttView.DurationUnits.Minutes; task2.ID = 132267904; task2.Mode = C1.Win.GanttView.TaskMode.Automatic; task2.Name = "Hit the hare"; task2.Start = new System.DateTime(2015, 4, 4, 0, 0, 0, 0); var task3 = c1GanttView1.Tasks[4]; task3.ConstraintDate = new System.DateTime(2012, 6, 28, 0, 0, 0, 0); task3.ConstraintType = C1.Win.GanttView.ConstraintType.StartNoEarlierThan; task3.Duration = 2; task3.ID = 1639616200; task3.Mode = C1.Win.GanttView.TaskMode.Automatic; task3.Name = "Skin that hare"; task3.Start = new System.DateTime(2015, 4, 6, 9, 12, 0, 0); var task4 = c1GanttView1.Tasks[6]; task4.ConstraintDate = new System.DateTime(2012, 6, 29, 0, 0, 0, 0); task4.ConstraintType = C1.Win.GanttView.ConstraintType.StartNoEarlierThan; task4.Duration = 3; task4.ID = 1784420689; task4.Mode = C1.Win.GanttView.TaskMode.Automatic; task4.Name = "Cook the hare"; task4.Start = new System.DateTime(2015, 4, 8, 9, 12, 0, 0); var task5 = c1GanttView1.Tasks[7]; task5.ConstraintDate = new System.DateTime(2012, 6, 30, 0, 0, 0, 0); task5.ConstraintType = C1.Win.GanttView.ConstraintType.StartNoEarlierThan; task5.Duration = 1; task5.ID = 1296539678; task5.Mode = C1.Win.GanttView.TaskMode.Automatic; task5.Name = "Eat the hare"; task5.Start = new System.DateTime(2015, 4, 13, 9, 12, 0, 0);

コードのコピー

//タスクを追加し、プロパティを設定します。
var task1 = c1GanttView1.Tasks[1];
task1.ConstraintDate = new System.DateTime(2012, 6, 22, 0, 0, 0, 0);
task1.ConstraintType = C1.Win.GanttView.ConstraintType.StartNoEarlierThan;
task1.Duration = 3;
task1.ID = 656460240;
task1.Mode = C1.Win.GanttView.TaskMode.Automatic;
task1.Name = "Pursue a hare";
task1.Start = new System.DateTime(2015, 4, 1, 0, 0, 0, 0);
var task2 = c1GanttView1.Tasks[2];
task2.ConstraintDate = new System.DateTime(2012, 6, 26, 0, 0, 0, 0);
task2.ConstraintType = C1.Win.GanttView.ConstraintType.StartNoEarlierThan;
task2.Duration = 12;
task2.DurationUnits = C1.Win.GanttView.DurationUnits.Minutes;
task2.ID = 132267904;
task2.Mode = C1.Win.GanttView.TaskMode.Automatic;
task2.Name = "Hit the hare";
task2.Start = new System.DateTime(2015, 4, 4, 0, 0, 0, 0);
var task3 = c1GanttView1.Tasks[4];
task3.ConstraintDate = new System.DateTime(2012, 6, 28, 0, 0, 0, 0);
task3.ConstraintType = C1.Win.GanttView.ConstraintType.StartNoEarlierThan;
task3.Duration = 2;
task3.ID = 1639616200;
task3.Mode = C1.Win.GanttView.TaskMode.Automatic;
task3.Name = "Skin that hare";
task3.Start = new System.DateTime(2015, 4, 6, 9, 12, 0, 0);
var task4 = c1GanttView1.Tasks[6];
task4.ConstraintDate = new System.DateTime(2012, 6, 29, 0, 0, 0, 0);
task4.ConstraintType = C1.Win.GanttView.ConstraintType.StartNoEarlierThan;
task4.Duration = 3;
task4.ID = 1784420689;
task4.Mode = C1.Win.GanttView.TaskMode.Automatic;
task4.Name = "Cook the hare";
task4.Start = new System.DateTime(2015, 4, 8, 9, 12, 0, 0);
var task5 = c1GanttView1.Tasks[7];
task5.ConstraintDate = new System.DateTime(2012, 6, 30, 0, 0, 0, 0);
task5.ConstraintType = C1.Win.GanttView.ConstraintType.StartNoEarlierThan;
task5.Duration = 1;
task5.ID = 1296539678;
task5.Mode = C1.Win.GanttView.TaskMode.Automatic;
task5.Name = "Eat the hare";
task5.Start = new System.DateTime(2015, 4, 13, 9, 12, 0, 0);

Add Resources to the C1GanttView.

C#	コードのコピー
//リソースを追加します。 Resource resource1 = new C1.Win.GanttView.Resource(); Resource resource2 = new C1.Win.GanttView.Resource(); Resource resource3 = new C1.Win.GanttView.Resource(); Resource resource4 = new C1.Win.GanttView.Resource(); resource1.Cost = new decimal(new int[] { 20000, 0, 0, 131072}); resource1.ID = 457479171; resource1.Name = "Adam Miller"; resource2.Cost = new decimal(new int[] { 50000, 0, 0, 131072}); resource2.ID = 574928631; resource2.Name = "Ruth Radelet"; resource3.Cost = new decimal(new int[] { 25000, 0, 0, 131072}); resource3.ID = 1258408175; resource3.Name = "Johnny Jewel"; resource4.Cost = new decimal(new int[] { 40000, 0, 0, 131072}); resource4.ID = 187715318; resource4.Name = "Nat Walker"; this.c1GanttView1.Resources.Add(resource1); this.c1GanttView1.Resources.Add(resource2); this.c1GanttView1.Resources.Add(resource3); this.c1GanttView1.Resources.Add(resource4);

コードのコピー

//リソースを追加します。
Resource resource1 = new C1.Win.GanttView.Resource();
Resource resource2 = new C1.Win.GanttView.Resource();
Resource resource3 = new C1.Win.GanttView.Resource();
Resource resource4 = new C1.Win.GanttView.Resource();
resource1.Cost = new decimal(new int[] {
   20000,
   0,
   0,
   131072});
resource1.ID = 457479171;
resource1.Name = "Adam Miller";
resource2.Cost = new decimal(new int[] {
   50000,
   0,
   0,
   131072});
resource2.ID = 574928631;
resource2.Name = "Ruth Radelet";
resource3.Cost = new decimal(new int[] {
   25000,
   0,
   0,
   131072});
resource3.ID = 1258408175;
resource3.Name = "Johnny Jewel";
resource4.Cost = new decimal(new int[] {
   40000,
   0,
   0,
   131072});
resource4.ID = 187715318;
resource4.Name = "Nat Walker";
this.c1GanttView1.Resources.Add(resource1);
this.c1GanttView1.Resources.Add(resource2);
this.c1GanttView1.Resources.Add(resource3);
this.c1GanttView1.Resources.Add(resource4);

Assign resources to the specific task. The added resources can be assigned to a specific task by creating a resource reference.

C#	コードのコピー
//リソースの参照を追加します。 ResourceRef resourceRef1 = new C1.Win.GanttView.ResourceRef(); ResourceRef resourceRef2 = new C1.Win.GanttView.ResourceRef(); ResourceRef resourceRef3 = new C1.Win.GanttView.ResourceRef(); ResourceRef resourceRef4 = new C1.Win.GanttView.ResourceRef(); ResourceRef resourceRef5 = new C1.Win.GanttView.ResourceRef(); ResourceRef resourceRef6 = new C1.Win.GanttView.ResourceRef(); ResourceRef resourceRef7 = new C1.Win.GanttView.ResourceRef(); resourceRef1.Amount = 1; resourceRef1.ResourceID = 457479171; resourceRef2.ResourceID = 1258408175; task1.ResourceRefs.Add(resourceRef1); task1.ResourceRefs.Add(resourceRef2); resourceRef3.Amount = 1; resourceRef3.ResourceID = 187715318; task2.ResourceRefs.Add(resourceRef3); resourceRef4.Amount = 1; resourceRef4.ResourceID = 187715318; resourceRef5.Amount = 1; resourceRef5.ResourceID = 1258408175; task3.ResourceRefs.Add(resourceRef4); task3.ResourceRefs.Add(resourceRef5); resourceRef6.Amount = 1; resourceRef6.ResourceID = 574928631; task4.ResourceRefs.Add(resourceRef6); resourceRef7.Amount = 1; resourceRef7.ResourceID = 457479171; task5.ResourceRefs.Add(resourceRef7);

コードのコピー

//リソースの参照を追加します。
ResourceRef resourceRef1 = new C1.Win.GanttView.ResourceRef();
ResourceRef resourceRef2 = new C1.Win.GanttView.ResourceRef();
ResourceRef resourceRef3 = new C1.Win.GanttView.ResourceRef();
ResourceRef resourceRef4 = new C1.Win.GanttView.ResourceRef();
ResourceRef resourceRef5 = new C1.Win.GanttView.ResourceRef();
ResourceRef resourceRef6 = new C1.Win.GanttView.ResourceRef();
ResourceRef resourceRef7 = new C1.Win.GanttView.ResourceRef();

resourceRef1.Amount = 1;
resourceRef1.ResourceID = 457479171;
resourceRef2.ResourceID = 1258408175;
task1.ResourceRefs.Add(resourceRef1);
task1.ResourceRefs.Add(resourceRef2);
resourceRef3.Amount = 1;
resourceRef3.ResourceID = 187715318;
task2.ResourceRefs.Add(resourceRef3);
resourceRef4.Amount = 1;
resourceRef4.ResourceID = 187715318;
resourceRef5.Amount = 1;
resourceRef5.ResourceID = 1258408175;
task3.ResourceRefs.Add(resourceRef4);
task3.ResourceRefs.Add(resourceRef5);
resourceRef6.Amount = 1;
resourceRef6.ResourceID = 574928631;
task4.ResourceRefs.Add(resourceRef6);
resourceRef7.Amount = 1;
resourceRef7.ResourceID = 457479171;
task5.ResourceRefs.Add(resourceRef7);

Add Predecessors to the tasks.

C#	コードのコピー
//先行タスクを追加します。 Predecessor predecessor1 = new C1.Win.GanttView.Predecessor(); Predecessor predecessor2 = new C1.Win.GanttView.Predecessor(); Predecessor predecessor3 = new C1.Win.GanttView.Predecessor(); Predecessor predecessor4 = new C1.Win.GanttView.Predecessor(); predecessor1.PredecessorTaskID = 656460240; task2.Predecessors.Add(predecessor1); predecessor2.PredecessorTaskID = 132267904; task3.Predecessors.Add(predecessor2); predecessor3.PredecessorTaskID = 1639616200; task4.Predecessors.Add(predecessor3); predecessor4.PredecessorTaskID = 1784420689; task5.Predecessors.Add(predecessor4);

コードのコピー

//先行タスクを追加します。
Predecessor predecessor1 = new C1.Win.GanttView.Predecessor();
Predecessor predecessor2 = new C1.Win.GanttView.Predecessor();
Predecessor predecessor3 = new C1.Win.GanttView.Predecessor();
Predecessor predecessor4 = new C1.Win.GanttView.Predecessor();
predecessor1.PredecessorTaskID = 656460240;
task2.Predecessors.Add(predecessor1); 
predecessor2.PredecessorTaskID = 132267904;
task3.Predecessors.Add(predecessor2);
predecessor3.PredecessorTaskID = 1639616200;
task4.Predecessors.Add(predecessor3);
predecessor4.PredecessorTaskID = 1784420689;
task5.Predecessors.Add(predecessor4);

Configure the GanttView Control. Add the following code to configure the grid.

C#	コードのコピー
gv.Dock = DockStyle.Fill; gv.BackColor = Color.LavenderBlush; gv.FixedFont = new Font("Microsoft Sans serif", 9, FontStyle.Bold);

This section walks you through step-by-step instructions for achieving data binding in GanttView for .NET 4.5.2 framework.

GanttView, when bound to a data source, fetches the required data from the underlying data source. Data binding additionally lets multiple data consumers to be connected to a single data provider in a synchronized manner. GanttView supports data binding to most of the commonly used data sources such as BindingSource, ADO.NET objects such as DataSet, DataTable etc.

Binding at design time

Step1: Configure the Data Source

Click View | Other Windows | Data Sources.
In Data Sources window, click Add New Data Source link to open Data Source Configuration Wizard window. Select Database as the Data Source Type and then click Next.
After clicking Next, select Dataset as the database model in Data Source Configuration Wizard window and click Next.
Select Data Connection by browsing C1NWind.mdb database file in your system. Test the connection and click Next. Save the connection string to add the database file to your project and click Next.
Choose Tables as Database Object Model in Data Source Configuration Wizard window.
Select Calendars, Properties, Resources and Tasks tables as object models from the drop-down list appearing under Tables and click Finish.
Navigate to the Toolbox again and locate the BindingSource icon in Data. Double-click the BindingSource icon to add it to the Design View.
Click the BindingSource once and set the DataSource property to c1NWindDataSet and DataMember as Tasks using the drop-down arrow in the Properties window. Delete the BindingSource from the design view after setting these properties.
Repeat Step 8 for Calendars, Resources and Properties tables to set their DataSource as c1NWindDataSet and DataMember as Calendars, Resources and Properties, respectively.
This creates adapters for the added datasets in your project.

The above steps adds the required datasets to your project. Also, the Visual studio automatically creates the following code to fill the dataset:

C#	コードのコピー
// このコードは、データを「c1NWindDataSet1.Resources」テーブルにロードします。必要に応じて、移動または削除できます。 this.resourcesTableAdapter.Fill(this.c1NWindDataSet.Resources); // このコードは、データを「c1NWindDataSet1.Properties」テーブルにロードします。必要に応じて、移動または削除できます。 this.propertiesTableAdapter.Fill(this.c1NWindDataSet.Properties); // このコードは、データを「c1NWindDataSet1.Calendars」テーブルにロードします。必要に応じて、移動または削除できます。 this.calendarsTableAdapter.Fill(this.c1NWindDataSet.Calendars); // このコードは、データを「c1NWindDataSet1.Tasks」テーブルにロードします。必要に応じて、移動または削除できます。 this.tasksTableAdapter.Fill(this.c1NWindDataSet.Tasks);

コードのコピー

// このコードは、データを「c1NWindDataSet1.Resources」テーブルにロードします。 必要に応じて、移動または削除できます。
this.resourcesTableAdapter.Fill(this.c1NWindDataSet.Resources);
// このコードは、データを「c1NWindDataSet1.Properties」テーブルにロードします。 必要に応じて、移動または削除できます。
this.propertiesTableAdapter.Fill(this.c1NWindDataSet.Properties);
// このコードは、データを「c1NWindDataSet1.Calendars」テーブルにロードします。 必要に応じて、移動または削除できます。
this.calendarsTableAdapter.Fill(this.c1NWindDataSet.Calendars);
// このコードは、データを「c1NWindDataSet1.Tasks」テーブルにロードします。 必要に応じて、移動または削除できます。
this.tasksTableAdapter.Fill(this.c1NWindDataSet.Tasks);

Step2: Bind GanttView to the Data Source

To bind the GanttView control to the data source at the design time, follow the given steps:

Select the GanttView control and navigate to the Properties window to make the following settings under DataStorage component.
- CalendarStorage:
  - DataMember - Calendars
  - DataSource - c1NWindDataSet
- PropertyStorage:
  - DataMember - Properties
  - DataSource - c1NWindDataSet
- ResourceStorage:
  - DataMember - Resources
  - DataSource - c1NWindDataSet
- TaskStorage:
  - DataMember - Tasks
  - DataSource - c1NWindDataSet
In DefaultWorkingTimes component in Properties window, make the following settings.
- Interval_1:
  - Empty - False
  - From - 9:00 AM.
  - To - 1:00 PM
- Interval_2:
  - Empty - False
  - From - 2:00PM.
  - To - 6:00 AM
Click the ellipsis appearing in the CalendarStorage property to set the following mappings and click OK.
Click the ellipsis appearing in the PropertyStorage property to set the following mappings and click OK.
Click the ellipsis appearing in the ResourceStorage property to set the following mappings and click OK.

Click the ellipsis appearing in the TasksStorage property to set the following mappings and click OK.

Displays the Custom Task Storage properties dialog box.

Refer to the following table to see all the mappings required for TasksStorage property.

Id Mapping	Id
Initialized	Initialized
Task ID	TaskID
Next task ID	NextID
Outline parent ID	OutlineParentID
Summary	Summary
Name	Name
Start	Start
Finish	Finish
Duration	Duration
Mode	Mode
Calendar ID	CalendarID
Duration units	DurationUnits
Percent complete	PercentComplete
Deadline	Deadline
Constraint type	ConstraintType
Hide bar	HideBar
Predecessors	Predecessors
Resources	Resources
Custom fields	CustomFields
Notes	Notes

In the Resources property, add four resources through Resource Collection Editor. Name these resources as Resource 1, Resource 2 and so on.
Locate the TimeScale component in Properties window to make the following timescale settings.
- MiddleTier:
  - Units - Weeks
  - Count - 1
  - Format - nnn d
  - Visible - True
- BottomTier:
  - Units - Days
  - Count - 1
  - Format - w
  - Align - Center
  - Visible - True
  - UseFiscalYear - True