📄 datareader.aspx

📁 掌握学习.net开发的非常好的资料

💻 ASPX

字号:

<%@ Page Language="C#" debug="true" trace="false" Description="dotnetCHARTING Component"%>
<%@ Register TagPrefix="dotnet"  Namespace="dotnetCHARTING" Assembly="dotnetCHARTING"%>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat="server">
void Page_Load(Object sender,EventArgs e)
{
	//set global properties
    Chart.Title="Item sales report";
    
    // Set the x axis label
	Chart.ChartArea.XAxis.Label.Text="X Axis Label";

	// Set the y axis label
	Chart.ChartArea.YAxis.Label.Text="Y Axis Label";
    Chart.TempDirectory="temp";
    Chart.Debug=true;
    
    
   //Adding series programatically
   	Chart.Series.Name = "Item sales";
    SetData();
    Chart.SeriesCollection.Add();
                       
   
}
void SetData()
{
	string connString = @"Provider=Microsoft.Jet.OLEDB.4.0;user id=admin;password=;data source=" + Server.MapPath("../../database/chartsample.mdb");  
    OleDbConnection conn = new OleDbConnection(connString);
   
    string selectQuery = @"SELECT Name,Sum(Quantity) FROM Orders GROUP BY Orders.Name ORDER BY Orders.Name"; 
    OleDbCommand myCommand = new OleDbCommand(selectQuery, conn);
   	conn.Open();
   	OleDbDataReader myReader= myCommand.ExecuteReader();
   	
   	//set dataReader to data property
   	Chart.Series.Data = myReader;
   	
   	//Cleanup
 	myReader.Close();
   	conn.Close();
}

</script>
<HTML><HEAD><TITLE>Data Reader Sample</TITLE></HEAD>
<BODY>
<DIV align=center>
 <dotnet:Chart id="Chart"  runat="server"/>
</DIV>
</BODY>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -