seriesaxisbindingdb.aspx

来自「掌握学习.net开发的非常好的资料」· ASPX 代码 · 共 85 行

ASPX
85
字号
<%@ Page Language="C#"  debug="true" 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 = @"Provider=Microsoft.Jet.OLEDB.4.0;user id=admin;password=;data source=" + Server.MapPath("../../database/chartsample.mdb");  
    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 = @"Provider=Microsoft.Jet.OLEDB.4.0;user id=admin;password=;data source=" + Server.MapPath("../../database/chartsample.mdb");  
    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.Width=540;


    
    //Add a series
    Chart2.Series.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;user id=admin;password=;data source=" + Server.MapPath("../../database/chartsample.mdb");  
    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 = @"Provider=Microsoft.Jet.OLEDB.4.0;user id=admin;password=;data source=" + Server.MapPath("../../database/chartsample.mdb");  
    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.Label.Text = "Sales";
    Chart2.Series.YAxis = ATotal; 
    Chart2.SeriesCollection.Add();

  
}
</script>
<HTML><HEAD><TITLE>Series Axis Binding DB Sample</TITLE></HEAD>
<BODY>
<DIV align=center>
 
  

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

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?