// *DYNAMIC DATA NOTE* // This sample uses random data to populate the chart. To populate // a chart with database data see the following resources: // - Use the getLiveData() method using the dataEngine to query a database. // - Help File > Getting Started > Data Tutorials // - DataEngine Class in the help file // - Sample: features/DataEngine.aspx
SeriesCollection mySC = getRandomData();
// Add the random data. Chart.SeriesCollection.Add(mySC); } }
SeriesCollection getRandomData() { Random myR = new Random(1); SeriesCollection SC = new SeriesCollection(); for (int a = 1; a < 5; a++) { Series s = new Series("Series " + a.ToString()); for (int b = 1; b < 5; b++) { Element e = new Element("Element " + b.ToString()); e.YValue = myR.Next(50); s.Elements.Add(e); } SC.Add(s); } return SC; }
SeriesCollection getLiveData() { DataEngine de = new DataEngine(ConfigurationManager.AppSettings["DNCConnectionString"]); de.ChartObject = Chart; // Necessary to view any errors the dataEngine may throw. de.SqlStatement = "SELECT XAxisColumn, YAxisColumn FROM ...."; return de.GetSeries(); }
Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) ' Demonstrates a javascript chart with clickable elements.
' Catch clicked value Dim clickedValue As String = Request.QueryString("value") If Not clickedValue Is Nothing AndAlso clickedValue.Length > 0 Then label1.Text = "Clicked Element Value: " & clickedValue
' *DYNAMIC DATA NOTE* ' This sample uses random data to populate the chart. To populate ' a chart with database data see the following resources: ' - Use the getLiveData() method using the dataEngine to query a database. ' - Help File > Getting Started > Data Tutorials ' - DataEngine Class in the help file ' - Sample: features/DataEngine.aspx
Dim mySC As SeriesCollection = getRandomData()
' Add the random data. Chart.SeriesCollection.Add(mySC) End If End Sub
Function getRandomData() As SeriesCollection Dim myR As Random = New Random(1) Dim SC As SeriesCollection = New SeriesCollection() For a As Integer = 1 To 4 Dim s As Series = New Series("Series " & a.ToString()) For b As Integer = 1 To 4 Dim e As Element = New Element("Element " & b.ToString()) e.YValue = myR.Next(50) s.Elements.Add(e) Next b SC.Add(s) Next a Return SC End Function
Function getLiveData() As SeriesCollection Dim de As DataEngine = New DataEngine(ConfigurationManager.AppSettings("DNCConnectionString")) de.ChartObject = Chart ' Necessary to view any errors the dataEngine may throw. de.SqlStatement = "SELECT XAxisColumn, YAxisColumn FROM ...." Return de.GetSeries() End Function
Previous