📄 datareadersql.aspx

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

💻 ASPX

字号:

<%@ Page Language="C#" debug="false" trace="false" Description="dotnetCHARTING Component"%>
<%@ Register TagPrefix="dotnet"  Namespace="dotnetCHARTING" Assembly="dotnetCHARTING"%>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<!-- To make this sample works:
1- upsize the provided chartsample access database (Tools->Database Utilities->upsizing wizard)
2-set connection string server, userid,password and database name.
-->
<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 = @"server=server name or IP;uid=username;pwd=password;database=database name";
    SqlConnection conn = new SqlConnection(connString);
    string selectQuery = @"SELECT Name,Sum(Quantity) FROM Orders GROUP BY Orders.Name ORDER BY Orders.Name"; 
    SqlCommand myCommand = new SqlCommand(selectQuery, conn);
   	conn.Open();
   	SqlDataReader myReader= myCommand.ExecuteReader();
   	
   	//set dataReader to data property
   	Chart.Series.Data = myReader;
   	
   	//Cleanup
 	myReader.Close();
   	conn.Close();
   
}
</script>
<HTML><HEAD><TITLE>Data Reader SQL 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 + -