The /NET version provides the following methods for data binding:
- DataSource, gets or sets the data source that the control is displaying data for. By default, this property is empty object. The DataSource property can be: DataTable, DataView, DataSet, DataViewManager, any component that implements the IListSource interface, or any component that implements the IList interface.
- DataMember, indicates a sub-list of the DataSource to show in the control. By default, this property is "". For instance, if DataSource property is a DataSet, the DataMember should indicates the name of the table to be loaded.
- DataTaskStart, The DataTaskStart property gets or sets the specific field in the data source to indicate the starting point of each added task. If missing or empty, no tasks are loaded during binding. In other words, it indicates the field to use be used as the starting point for each task in any record. This member is automatically filled with the first DATE field from the DataSource, when it is set. This member is automatically filled with the first DATE field from the data source ( DataSource/DataMember ).
- DataTaskEnd, DataTaskEnd property gets or sets the specific field in the data source to indicate the ending point of each added task. If missing or empty, no tasks are loaded during binding. If the DataTaskEnd points to a DateTime object, it indicates the ending date of the newly bar, else, it indicates the duration of the task to be added. If the DataTaskEnd is equal with DataTaskBegin, a one-day task is added for each record found, during binding. This member is automatically filled with the second DATE field from the DataSource collection. This member can be of DATE type, which indicates the exBarEnd property of any bar in the collection, or a DOUBLE, when it indicates the length/duration of the bar to be added.
Using the data binding on /NET may change the following properties:
- Items.AllowCellValueToItemBar on True
- Column(Start).Def(exCellValueToItemBarProperty) on exBarStart
- Column(End).Def(exCellValueToItemBarProperty) on exBarEnd, exBarStart or exBarDuration ( if DOUBLE field is found )
Click here 
to watch a movie on how to assign a data source to the control, in design
mode, for /NET assembly.
The following VB sample binds an ADO recordset to the ExG2antt/COM control:
Set rs = CreateObject("ADODB.Recordset")
rs.Open "Orders", "Provider=Microsoft.Jet.OLEDB.3.51;Data Source= D:\Program Files\Microsoft Visual Studio\VB98\NWIND.MDB", 3 ' Opens the table using static mode
Set G2antt1.DataSource = rs
The DataSource clears the columns collection, and load the recordset to the control. Use SetParent method to make your list a hierarchy.
The following C++ sample binds a table to the control:
#include "Items.h"
#include "Columns.h"
#include "Column.h"
#pragma warning( disable : 4146 )
#import <msado15.dll> rename ( "EOF", "adoEOF" )
using namespace ADODB;
_RecordsetPtr spRecordset;
if ( SUCCEEDED( spRecordset.CreateInstance( "ADODB.Recordset") ) )
{
// Builds the connection string.
CString strTableName = "Employees", strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
CString strPath = "D:\\Program Files\\Microsoft Visual Studio\\VB98\\NWIND.MDB";
strConnection += strPath;
try
{
// Loads the table
if ( SUCCEEDED( spRecordset->Open(_variant_t( (LPCTSTR)strTableName ), _variant_t((LPCTSTR)strConnection), adOpenStatic, adLockPessimistic, NULL ) ) )
{
m_g2antt.BeginUpdate();
m_g2antt.SetColumnAutoResize( FALSE );
m_g2antt.SetDataSource( spRecordset );
m_g2antt.EndUpdate();
}
}
catch ( _com_error& e )
{
AfxMessageBox( e.Description() );
}
}
The #import statement imports definitions for ADODB type library, that's used to fill the control.
The following C# sample binds at runtime a table to the /NET component, using the DataSource property:
private DataTable GetTable()
{
DataTable table = new DataTable();
table.Columns.Add("Dosage", typeof(int));
table.Columns.Add("Drug", typeof(String));
table.Columns.Add("Patient", typeof(String));
table.Columns.Add("DateIn", typeof(DateTime));
table.Columns.Add("DateOut", typeof(DateTime));
table.Rows.Add(25, "Indocin", "David", DateTime.Today, DateTime.Today.AddDays(2));
table.Rows.Add(50, "Enebrel", "Sam", DateTime.Today.AddDays(2), DateTime.Today.AddDays(4));
table.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Today.AddDays(4), DateTime.Today.AddDays(8));
table.Rows.Add(21, "Combivent", "Janet", DateTime.Today.AddDays(2), DateTime.Today.AddDays(6));
table.Rows.Add(100, "Dilantin", "Melanie", DateTime.Today.AddDays(1), DateTime.Today.AddDays(3));
return table;
}
private void Form1_Load(object sender, EventArgs e)
{
Exgantt1.BeginUpdate();
Exgantt1.DefaultItemHeight = 25;
Exgantt1.DataSource = GetTable();
Exgantt1.Chart.LevelCount = 2;
Exgantt1.EndUpdate();
}
The following VB.NET sample binds at runtime a table to the /NET component, using the DataSource property:
Function GetTable() As DataTable
Dim table As DataTable = New DataTable()
table.Columns.Add("Dosage", GetType(Long))
table.Columns.Add("Drug", GetType(String))
table.Columns.Add("Patient", GetType(String))
table.Columns.Add("DateIn", GetType(DateTime))
table.Columns.Add("DateOut", GetType(DateTime))
table.Rows.Add(25, "Indocin", "David", DateTime.Today, DateTime.Today.AddDays(2))
table.Rows.Add(50, "Enebrel", "Sam", DateTime.Today.AddDays(2), DateTime.Today.AddDays(4))
table.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Today.AddDays(4), DateTime.Today.AddDays(8))
table.Rows.Add(21, "Combivent", "Janet", DateTime.Today.AddDays(2), DateTime.Today.AddDays(6))
table.Rows.Add(100, "Dilantin", "Melanie", DateTime.Today.AddDays(1), DateTime.Today.AddDays(3))
GetTable = table
End Function
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
With Exgantt1
.BeginUpdate()
.DefaultItemHeight = 25
.DataSource = GetTable()
.Chart.LevelCount = 2
.EndUpdate()
End With
End Sub