void Page_Load(Object sender, EventArgs e) { // Demonstrates making a simple tree organizational chart using the DB and with rich tooltips detailing each node.
// Setup the chart. Chart.Size = "900x380"; Chart.TempDirectory = "temp"; Chart.Debug = true; Chart.Type = ChartType.Organizational; Chart.Title = "Hover over nodes for details"; Chart.TitleBox.ClearColors();
// Style the default annotation. Chart.DefaultElement.Annotation = new Annotation(); Chart.DefaultElement.Annotation.Padding = 5; Chart.DefaultElement.Annotation.Size = new Size(70, 25); Chart.DefaultElement.Annotation.DefaultCorner = BoxCorner.Square; Chart.DefaultElement.Annotation.Line = new Line(Color.Gray, 2, DashStyle.Dash); Chart.DefaultElement.Annotation.Label.Text = "<block fSize='12'>%Name"; Chart.DefaultElement.Annotation.Background.Color = Color.FromArgb(250, 250, 250);
// Define the tooltip with for each node with details. Chart.DefaultElement.Annotation.Hotspot.ToolTip = "<block fStyle='bold' fSize='15'>%name<row><img:../../images/Org%picture><block halign='right'>%Department<br>%Email<br>%phone<br>Office #%office";
// Add the data. Chart.SeriesCollection.Add(getLiveData()); }
SeriesCollection getLiveData() { // Obtain series data from the database. Note this was created by adding PID (parentid) // to an existing table only, then populating the parentid based on the hiearchy in place. DataEngine de = new DataEngine(ConfigurationManager.AppSettings["DNCConnectionString"]); de.SqlStatement = @"SELECT * FROM Employees"; de.DataFields = "InstanceID=ID,InstanceParentID=PID,Name=Name,office,Department,Email,Phone,Picture"; return de.GetSeries(); }
Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) ' Demonstrates making a simple tree organizational chart using the DB and with rich tooltips detailing each node.
' Setup the chart. Chart.Size = "900x380" Chart.TempDirectory = "temp" Chart.Debug = True Chart.Type = ChartType.Organizational Chart.Title = "Hover over nodes for details" Chart.TitleBox.ClearColors()
' Style the default annotation. Chart.DefaultElement.Annotation = New Annotation() Chart.DefaultElement.Annotation.Padding = 5 Chart.DefaultElement.Annotation.Size = New Size(70, 25) Chart.DefaultElement.Annotation.DefaultCorner = BoxCorner.Square Chart.DefaultElement.Annotation.Line = New Line(Color.Gray, 2, DashStyle.Dash) Chart.DefaultElement.Annotation.Label.Text = "<block fSize='12'>%Name" Chart.DefaultElement.Annotation.Background.Color = Color.FromArgb(250, 250, 250)
' Define the tooltip with for each node with details. Chart.DefaultElement.Annotation.Hotspot.ToolTip = "<block fStyle='bold' fSize='15'>%name<row><img:../../images/Org%picture><block halign='right'>%Department<br>%Email<br>%phone<br>Office #%office"
' Add the data. Chart.SeriesCollection.Add(getLiveData()) End Sub
Function getLiveData() As SeriesCollection ' Obtain series data from the database. Note this was created by adding PID (parentid) ' to an existing table only, then populating the parentid based on the hiearchy in place. Dim de As DataEngine = New DataEngine(ConfigurationManager.AppSettings("DNCConnectionString")) de.SqlStatement = "SELECT * FROM Employees" de.DataFields = "InstanceID=ID,InstanceParentID=PID,Name=Name,office,Department,Email,Phone,Picture" Return de.GetSeries() End Function
Previous