// Style the default annotation. Chart.DefaultElement.Annotation = new Annotation(); Chart.DefaultElement.Annotation.Size = new Size(60, 18); Chart.DefaultElement.Annotation.Label.Text = "<block fSize='12'>%Name"; Chart.DefaultElement.Annotation.ClearColors();
// 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(); }
' Style the default annotation. Chart.DefaultElement.Annotation = New Annotation() Chart.DefaultElement.Annotation.Size = New Size(60, 18) Chart.DefaultElement.Annotation.Label.Text = "<block fSize='12'>%Name" Chart.DefaultElement.Annotation.ClearColors()
' 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