datareadersql.aspx

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

ASPX

52 行

<%@ Page Language="VB" 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">
Sub Page_Load(sender As Object,e As EventArgs )

	'set global properties
    Chart.Title="Item sales report"
	Chart.ChartArea.XAxis.Label.Text="Customers"
    Chart.TempDirectory="temp"
    Chart.Debug=true
    
    
    'Adding series programatically
   	Chart.Series.Name = "Item sales"
   	SetData()
    Chart.SeriesCollection.Add()
                       
   
End sub
Function  SetData()
	Dim  connString As String = "server=server name or IP;uid=username;pwd=password;database=database name"  
    Dim conn As SqlConnection  = new SqlConnection(connString)
    Dim selectQuery As string = "SELECT Name,Sum(Quantity) FROM Orders GROUP BY Orders.Name ORDER BY Orders.Name"
    Dim myCommand As SqlCommand  = new SqlCommand(selectQuery, conn)
   	conn.Open()
   	Dim myReader As SqlDataReader = myCommand.ExecuteReader()
   	
   	'set dataReader to data property
   	Chart.Series.Data = myReader
   	
   	'Cleanup
 	myReader.Close()
   	conn.Close()
End Function
</script>
<HTML><HEAD><TITLE>Data Reader SQL Sample</TITLE></HEAD>
<BODY>
<DIV align=center>
 <dotnet:Chart id="Chart"  runat="server"/>
</DIV>
</BODY>
</BODY>
</HTML>

datareadersql.aspx - 源码说明

本页面展示了「掌握学习.net开发的非常好的资料」中的 datareadersql.aspx 源码文件，采用 ASPX 编程语言编写，共 52 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与.NET相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?