www.Chart4.NET | Samples

Property collection of Data-binding/import and node-customization methods for hierarchy controls, accessible through HierarchyWin-hpcData and HierarchyWeb-hpcData property. [h]iearachy [p]roperty [c]ollection of [Data].

Namespace:  UnifoChart.Hierarchy
Assembly:  UnifoChart.Hierarchy (in UnifoChart.Hierarchy.dll) Version: 2.6.0.0 (2.6)

Syntax

C#
public sealed class HierarchyData
Visual Basic (Declaration)
Public NotInheritable Class HierarchyData
Visual Basic (Usage)
Dim instance As HierarchyData
Visual C++
public ref class HierarchyData sealed
J#
public final class HierarchyData
JScript
public final class HierarchyData
JavaScript
UnifoChart.Hierarchy.HierarchyData = function();

Type.createClass(
	'UnifoChart.Hierarchy.HierarchyData');

Remarks

Following is a sample database connection to fill the data:
CopyC#
hierarchy1.hpcData.PhotoSpecification = PhotoSpecificationType.ByFileName;
System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection();
conn.ConnectionString = "Driver={SQL Server};Server=.\\SQLEXPRESS;Database=test1;Trusted_Connection=Yes;";
//Check sResult for any errors
string sResult = hierarchy1.hpcData.LoadFromDatabase( 
        conn, "Parc", "id", "pid", "txt", "", "", "tooltip", "imagefile" );
hierarchy1.hpDataTree.ExpandAll( );            
hierarchy1.Refresh( );

Following is the sample table:
CopySQL
CREATE TABLE [dbo].[Parc](
    [id] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [pid] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [txt] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [value] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [tooltip] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [imagefile] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

Following is the sample data: 
            id	pid	txt	value	tooltip	imagefile
            -----------------------------------------------
            1	0	Text1	NULL	NULL	add.png
            2	6	Text2	NULL	NULL	NULL
            3	1	Text3	NULL	tooltip1	add.png
            4		Text4	NULL	NULL	NULL
            5	2	Text5	NULL	NULL	NULL
            6	NULL	Text6	NULL	NULL	NULL
  • See also How to Create Organization Chart from Database/ODBC.
  • Use LoadFromDatabase() with an SQL query, to provide extra information (eg:url, tag etc.).
  • If you use an SQL query, put the standard names (Id, ParentId, text, value, tooltip, photo, url, tag) for the columns of the table.
  • Alternately you can use column aliases:
    CopySQL
    SELECT    column1 AS Id, 
            column2 AS ParentId, 
            column3 AS [text], 
            column4 AS [value], 
            column5 AS tooltip, 
            column6 AS photo, 
            column7 AS url, 
            column8 AS tag
FROM    Parc
WHERE    location=7
  • See LoadFromXmlFile() for the desired XML format and remarks.

Inheritance Hierarchy

System..::.Object
  UnifoChart.Hierarchy..::.HierarchyData

See Also