Gallery

Gallery > Axis And Scales

Series Axis Bindingdb

Shows total sales and number of orders from the sample database bound to different axis and also shows how the same chart would appear if bound to the same axis.

Download Show C# Code Show VB Code

<%@ 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)
{
//set global properties
Chart.Title="Orders and Sales by Customers";
Chart.XAxis.Label.Text="Customers";
Chart.TempDirectory="temp";
Chart.Debug=true;
Chart.ChartArea.Shadow.Depth=10;
Chart.Width=400;

//Add a series
Chart.Series.ConnectionString = ConfigurationManager.AppSettings["DNCConnectionString"];
Chart.Series.Name="Orders";
Chart.Series.Limit ="5";
Chart.Series.SqlStatement= @"SELECT Name,Sum(1) FROM Orders GROUP BY Name ORDER BY Name DESC";
Chart.Series.Type = SeriesType.Cylinder;
Chart.SeriesCollection.Add();

//Add a series
Chart.Series.ConnectionString = ConfigurationManager.AppSettings["DNCConnectionString"];
Chart.Series.Name="Sales";
Chart.Series.Limit ="5";
Chart.Series.SqlStatement= @"SELECT Name,Sum(Total) FROM Orders GROUP BY Name ORDER BY Name DESC";
Chart.Series.Type = SeriesType.Cylinder;
Chart.SeriesCollection.Add();

//set global properties
Chart2.Title="Orders and Sales by Customers";
Chart2.XAxis.Label.Text="Customers";
Chart2.YAxis.Label.Text="Orders";
Chart2.TempDirectory="temp";
Chart2.Debug=true;
Chart2.ChartArea.Shadow.Depth=10;
//Chart2.ChartArea.Shadow.Color = Color.Red;
//Chart2.DefaultChartArea.Shadow.Color = Color.Red;
Chart2.DefaultBox.Shadow.Visible = true;
Chart2.Width=540;
Chart2.YAxis.Interval = 100;
//Chart2.LegacyMode = true;

//Add a series
Chart2.Series.ConnectionString = ConfigurationManager.AppSettings["DNCConnectionString"];
Chart2.Series.Name="Orders";
Chart2.Series.Limit ="5";
Chart2.Series.SqlStatement= @"SELECT Name,Sum(1) FROM Orders GROUP BY Name ORDER BY Name DESC";
Chart2.Series.Type = SeriesType.Cylinder;
Chart2.SeriesCollection.Add();

//Add a series
Chart2.Series.ConnectionString = ConfigurationManager.AppSettings["DNCConnectionString"];
Chart2.Series.Name="Sales";
Chart2.Series.Limit ="5";
Chart2.Series.SqlStatement= @"SELECT Name,Sum(Total) FROM Orders GROUP BY Name ORDER BY Name DESC";
Chart2.Series.Type = SeriesType.Cylinder;
Axis ATotal = new Axis();
ATotal.Orientation = dotnetCHARTING.Orientation.Right;
ATotal.Interval = 10000;
ATotal.Label.Text = "Sales";
Chart2.Series.YAxis = ATotal;
Chart2.SeriesCollection.Add();

}
</script>
<html xmlns="http://www.w3.org/1999/xhtml"><head><title>Series Axis Binding DB Sample</title></head>
<body>
<div style="text-align:center">

</div>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td width="50%"> <dotnet:Chart id="Chart" runat="server"/></td>
<td width="50%"> <dotnet:Chart id="Chart2" runat="server"/></td>

</tr>
</table>
</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)
'set global properties
Chart.Title="Orders and Sales by Customers"
Chart.XAxis.Label.Text="Customers"
Chart.TempDirectory="temp"
Chart.Debug=True
Chart.ChartArea.Shadow.Depth=10
Chart.Width=400

'Add a series
Chart.Series.ConnectionString = ConfigurationManager.AppSettings("DNCConnectionString")
Chart.Series.Name="Orders"
Chart.Series.Limit ="5"
Chart.Series.SqlStatement= "SELECT Name,Sum(1) FROM Orders GROUP BY Name ORDER BY Name DESC"
Chart.Series.Type = SeriesType.Cylinder
Chart.SeriesCollection.Add()

'Add a series
Chart.Series.ConnectionString = ConfigurationManager.AppSettings("DNCConnectionString")
Chart.Series.Name="Sales"
Chart.Series.Limit ="5"
Chart.Series.SqlStatement= "SELECT Name,Sum(Total) FROM Orders GROUP BY Name ORDER BY Name DESC"
Chart.Series.Type = SeriesType.Cylinder
Chart.SeriesCollection.Add()

'set global properties
Chart2.Title="Orders and Sales by Customers"
Chart2.XAxis.Label.Text="Customers"
Chart2.YAxis.Label.Text="Orders"
Chart2.TempDirectory="temp"
Chart2.Debug=True
Chart2.ChartArea.Shadow.Depth=10
'Chart2.ChartArea.Shadow.Color = Color.Red;
'Chart2.DefaultChartArea.Shadow.Color = Color.Red;
Chart2.DefaultBox.Shadow.Visible = True
Chart2.Width=540
Chart2.YAxis.Interval = 100
'Chart2.LegacyMode = true;

'Add a series
Chart2.Series.ConnectionString = ConfigurationManager.AppSettings("DNCConnectionString")
Chart2.Series.Name="Orders"
Chart2.Series.Limit ="5"
Chart2.Series.SqlStatement= "SELECT Name,Sum(1) FROM Orders GROUP BY Name ORDER BY Name DESC"
Chart2.Series.Type = SeriesType.Cylinder
Chart2.SeriesCollection.Add()

'Add a series
Chart2.Series.ConnectionString = ConfigurationManager.AppSettings("DNCConnectionString")
Chart2.Series.Name="Sales"
Chart2.Series.Limit ="5"
Chart2.Series.SqlStatement= "SELECT Name,Sum(Total) FROM Orders GROUP BY Name ORDER BY Name DESC"
Chart2.Series.Type = SeriesType.Cylinder
Dim ATotal As Axis = New Axis()
ATotal.Orientation = dotnetCHARTING.Orientation.Right
ATotal.Interval = 10000
ATotal.Label.Text = "Sales"
Chart2.Series.YAxis = ATotal
Chart2.SeriesCollection.Add()

End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml"><head><title>Series Axis Binding DB Sample</title></head>
<body>
<div style="text-align:center">

</div>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td width="50%"> <dotnet:Chart id="Chart" runat="server"/></td>
<td width="50%"> <dotnet:Chart id="Chart2" runat="server"/></td>

</tr>
</table>
</body>
</html>

Sample FilenameSeriesAxisBindingdb.aspx
VersionLegacy (Pre 3.0)
Uses DatabaseYes

JS Charting

Gallery

Series Axis Bindingdb