Gallery
Pyramid
<%@ Page Language="C#" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING"%>
<%@ Import Namespace="System.Drawing" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>.netCHARTING Sample</title>
<script runat="server">
void Page_Load(Object sender,EventArgs e)
{
//set global properties
Chart.Title="Item sales";
Chart.Type = ChartType.ComboHorizontal;
Chart.Size = "800X400";
Chart.TempDirectory="temp";
Chart.Debug=true;
Chart.DefaultElement.ShowValue = true;
//Add a series
DataEngine de = new DataEngine();
de.ConnectionString = ConfigurationManager.AppSettings["DNCConnectionString"];
de.StartDate=new DateTime (2022,1,1,0,0,0);
de.EndDate = new DateTime (2022,12,30,23,59,59);
de.DateGrouping = TimeInterval.Year;
de.SplitByLimit = "2";
// Chart 1
de.SqlStatement= @"SELECT OrderDate,Total,Name FROM Orders WHERE OrderDate >= #STARTDATE# AND OrderDate <= #ENDDATE# ORDER BY Orders.OrderDate";
SeriesCollection sc = de.GetSeries();
Chart.SeriesCollection.Add(sc[0]);
// Chart 2
ChartArea ca2 = new ChartArea();
Axis newX = new Axis();
newX.Label.Text = sc[0].Name + "'s Sales";
sc[1].XAxis = newX;
ca2.SeriesCollection.Add(sc[1]);
ca2.Label.Text = "Others";
Chart.ExtraChartAreas.Add(ca2);
Chart.XAxis.InvertScale = true;
Chart.XAxis.SynchronizeScale.Add(newX);
Chart.XAxis.Label.Text=sc[1].Name +"'s Sales";
}
</script>
</head>
<body>
<div style="text-align:center">
<dotnet:Chart id="Chart" runat="server" Width="568px" Height="344px">
</dotnet:Chart>
</div>
</body>
</html>
<%@ Page Language="vb" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING"%>
<%@ Import Namespace="System.Drawing" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>.netCHARTING Sample</title>
<script runat="server">
Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
'set global properties
Chart.Title="Item sales"
Chart.Type = ChartType.ComboHorizontal
Chart.Size = "800X400"
Chart.TempDirectory="temp"
Chart.Debug=True
Chart.DefaultElement.ShowValue = True
'Add a series
Dim de As DataEngine = New DataEngine()
de.ConnectionString = ConfigurationManager.AppSettings("DNCConnectionString")
de.StartDate = New DateTime (2022,1,1,0,0,0)
de.EndDate = New DateTime (2022,12,30,23,59,59)
de.DateGrouping = TimeInterval.Year
de.SplitByLimit = "2"
' Chart 1
de.SqlStatement= "SELECT OrderDate,Total,Name FROM Orders WHERE OrderDate >= #STARTDATE# AND OrderDate <= #ENDDATE# ORDER BY Orders.OrderDate"
Dim sc As SeriesCollection = de.GetSeries()
Chart.SeriesCollection.Add(sc(0))
' Chart 2
Dim ca2 As ChartArea = New ChartArea()
Dim newX As Axis = New Axis()
newX.Label.Text = sc(0).Name & "'s Sales"
sc(1).XAxis = newX
ca2.SeriesCollection.Add(sc(1))
ca2.Label.Text = "Others"
Chart.ExtraChartAreas.Add(ca2)
Chart.XAxis.InvertScale = True
Chart.XAxis.SynchronizeScale.Add(newX)
Chart.XAxis.Label.Text=sc(1).Name & "'s Sales"
End Sub
</script>
</head>
<body>
<div style="text-align:center">
<dotnet:Chart id="Chart" runat="server" Width="568px" Height="344px">
</dotnet:Chart>
</div>
</body>
</html>
- Sample FilenamePyramid.aspx
- VersionLegacy (Pre 3.0)
- Uses DatabaseYes