// *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(); }
' *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)
' Create a new legendbox and apply header styling settings. Dim lb As LegendBox = New LegendBox() lb.Orientation = dotnetCHARTING.Orientation.Top lb.DataSource = mySC.GetDataSource() lb.DefaultCorner = BoxCorner.Square lb.Header.Label.Text = "Legend" lb.Header.StartAlignment = EdgeAlignment.Inside lb.Header.VerticalAlignment = EdgeAlignment.Edge lb.Header.StartCap = BoxCapStyle.TriangleInverted lb.Header.EndCap = BoxCapStyle.Box lb.Header.Offset = New Point(2, 0) lb.Header.Shadow.Color = Color.FromArgb(100, Color.Gray) lb.Header.Shadow.Soft = False lb.Header.Shadow.Depth = 3 Chart.ExtraLegendBoxes.Add(lb)
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