Gallery

Gallery > Interactivity

JS Live Data Update

Demonstrates adding time based points to the js chart in real-time.

Download Show C# Code Show VB Code

<%@ Page Language="C#" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dnc" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Drawing.Drawing2D" %>
<script runat="server">

void Page_Load(Object sender, EventArgs e)
{
// Demonstrates adding points to the js chart in real-time.

Chart.Size = "600x350";
Chart.Title = "DateTime chart data updated every second through Javascript.";
Chart.TempDirectory = "temp";
Chart.Debug = false;
Chart.LegendBox.Visible = false;

Chart.DefaultSeries.Type = SeriesType.Spline;

// Enable JSCharting
Chart.JS.Enabled = true;
Chart.JS.ControlID = "JscChart";
Chart.JS.Buttons.Orientation = dotnetCHARTING.Orientation.TopLeft;

Chart.XAxis.Scale = Scale.Time;

// *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();
DateTime dt = new DateTime(2011, 1, 1);//DateTime.Today.AddDays(-15);//

Series s = new Series("Series 1");
for (int b = 1; b < 10; b++)
{
Element e = new Element();
e.XDateTime = dt = dt.AddDays(1);
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();
}

</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>.netCHARTING Sample</title>
</head>
<script type="text/javascript">

var chartID = "JscChart";
var xVal = Date.UTC(2011, 0, 11);

setInterval(function () {
if (JscChart) {
var series = JscChart.series(0),
yVal = Math.random() * 50;

series.points.add({ x: new Date(xVal), y: yVal });
xVal = xVal + 1000 * 60 * 60 * 24;
}
}, 1000);

</script>
<body>
<div align="center">
<dnc:Chart ID="Chart" runat="server" />
</div>
</body>
</html>

<%@ Page Language="vb" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dnc" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Drawing.Drawing2D" %>
<script runat="server">

Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
' Demonstrates adding points to the js chart in real-time.

Chart.Size = "600x350"
Chart.Title = "DateTime chart data updated every second through Javascript."
Chart.TempDirectory = "temp"
Chart.Debug = False
Chart.LegendBox.Visible = False

Chart.DefaultSeries.Type = SeriesType.Spline

' Enable JSCharting
Chart.JS.Enabled = True
Chart.JS.ControlID = "JscChart"
Chart.JS.Buttons.Orientation = dotnetCHARTING.Orientation.TopLeft

Chart.XAxis.Scale = Scale.Time

' *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 Sub

Function getRandomData() As SeriesCollection
Dim myR As Random = New Random(1)
Dim SC As SeriesCollection = New SeriesCollection()
Dim dt As DateTime = New DateTime(2011, 1, 1) 'DateTime.Today.AddDays(-15);//

Dim s As Series = New Series("Series 1")
For b As Integer = 1 To 9
Dim e As Element = New Element()
dt = dt.AddDays(1)
e.XDateTime = dt
e.YValue = myR.Next(50)
s.Elements.Add(e)
Next b
SC.Add(s)

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

</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>.netCHARTING Sample</title>
</head>
<script type="text/javascript">

var chartID = "JscChart";
var xVal = Date.UTC(2011, 0, 11);

setInterval(function () {
if (JscChart) {
var series = JscChart.series(0),
yVal = Math.random() * 50;

series.points.add({ x: new Date(xVal), y: yVal });
xVal = xVal + 1000 * 60 * 60 * 24;
}
}, 1000);

</script>
<body>
<div align="center">
<dnc:Chart ID="Chart" runat="server" />
</div>
</body>
</html>

Sample FilenameJsLiveDataUpdate.aspx
Version8.0
Uses DatabaseNo

JS Charting

Gallery

JS Live Data Update