⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 seriesaxisbindingdb.aspx

📁 掌握学习.net开发的非常好的资料
💻 ASPX
字号:
🔍 
<%@ Page Language="VB"  debug="true" Description="dotnetCHARTING Component"%>
<%@ Register TagPrefix="dotnet"  Namespace="dotnetCHARTING" Assembly="dotnetCHARTING"%>
<%@ Import Namespace="System.Drawing" %>


<script runat="server">
Sub Page_Load(sender As Object,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=Unit.Parse(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=Unit.Parse(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
    Dim ATotal As Axis
    ATotal = new Axis()
    ATotal.Orientation = dotnetCHARTING.Orientation.Right
    ATotal.Label.Text = "Sales"
    Chart2.Series.YAxis = ATotal 
    Chart2.SeriesCollection.Add()

 End Sub
</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 + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -