Unifosys

Organization Chart from Multiple Linked Tables Chart4.NET

 Organization Chart from Multiple Tables using Chart4.NET Organization Chart Control

 Chart4.NET - Documentation  | Online-Demo  | Screens
Questions or suggestions? Quick Contact

The Chart4.NET component is a .NET assembly that you can use in Desktop (winform) and ASP.NET (webform) projects.


Sample Downloads

Following samples describe how to describe the table tree (table hierarchy) and to load data into the orgchart control.
Winform Sample Download DesignerSample
Webform(ASP.NET) Sample Download OrganizationChart4TablesWeb


Data Hierarchy

Following is a sample hierarchy of data:


org chart data hierarchy



Tables and Data Structure

Following is a list of tables to describe the above scenario. Please refer the samples above to see how to specify the table hierarchy to the chart control.
org chart table structure



Output: Table Organization Chart

Following is the organization chart created from the above set of tables and data.
org chart table organization chart



Applications

The above techhnique can be used for a database for any sort of application, where tables and data are linked through primary-key/foreign-key relationships. Please note the following things:
  • The explicit primary-key/foreign-key relationship described in database is not necessary. You have to specfy the relationship in code.
  • An explicit database is not necessary. You are basically loading the chart from DataTables.
  • It is not necessary to describe the leaf data always (if you have a lot of data). You can use the navigation fascility from the node-click (that will provide the selected table and id) to populate the details in a wider form. Refer DrillDownModeType for client-side and server-side navigation methods.
  • The important thing is that you (and end-user) get a consolidated and quick way to work with the application database.
  • Key methods used are HierarchyTable.Add() and HierarchyData.LoadFromTables().


  • Related Articles

  • How To Create Organization Chart from Database
  • Download Samples





  • Other Sample Downloads

  • Download an appropriate sample here (no installation required): Sample Downloads
  • Web Control Demo | Web Control Demo (Advanced) | Web Control Demo (Database)


  • Library Downloads

  • Library (demo version) is included in Sample Downloads
  • © 2014, Unifosys