Gallery
Quick DB Chart
<%@ Page Language="C#" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING"%>
<%@ Import Namespace="System.Drawing" %>
<script runat="server">
void Page_Load(Object sender,EventArgs e)
{
// Demonstrates quickly getting data from a database using API shortcuts.
Chart.Title = "Orders frequency for each month";
Chart.TempDirectory = "temp";
Chart.Debug = true;
Chart.DefaultSeries.PaletteName = Palette.Default;
Chart.Size = "600x350";
Chart.XAxis.Label.Text = "Months";
string SqlStatement = "SELECT OrderDate,1 FROM Orders ORDER BY Orders.OrderDate";
Chart.SeriesCollection.Add(DataEngine.GetSeries(ConfigurationManager.AppSettings["DNCConnectionString"],SqlStatement,TimeInterval.Year));
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head><title>.netCHARTING Sample</title></head>
<body>
<div align="center">
<dotnet:Chart id="Chart" runat="server"/>
</div>
</body>
</html>
<%@ Page Language="vb" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING"%>
<%@ Import Namespace="System.Drawing" %>
<script runat="server">
Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
' Demonstrates quickly getting data from a database using API shortcuts.
Chart.Title = "Orders frequency for each month"
Chart.TempDirectory = "temp"
Chart.Debug = True
Chart.DefaultSeries.PaletteName = Palette.Default
Chart.Size = "600x350"
Chart.XAxis.Label.Text = "Months"
Dim SqlStatement As String = "SELECT OrderDate,1 FROM Orders ORDER BY Orders.OrderDate"
Chart.SeriesCollection.Add(DataEngine.GetSeries(ConfigurationManager.AppSettings("DNCConnectionString"),SqlStatement,TimeInterval.Year))
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head><title>.netCHARTING Sample</title></head>
<body>
<div align="center">
<dotnet:Chart id="Chart" runat="server"/>
</div>
</body>
</html>
- Sample FilenameQuickDBChart.aspx
- Version4.1
- Uses DatabaseYes