GeekArticles
Database
SQL Server
Database
SQL ServerUsing Microsoft's Chart Controls In An ASP.NET Application: Adding Statistical Formulas
<p>
The Microsoft Chart controls make it easy to take data from a database or some other data store and present it as a chart. As discussed in <a Data</a>, the Chart controls offer a myriad of ways to get data into a chart. You can add the data programmatically, point-by-point, or you can bind an ADO.NET <code>DataTable</code>
directly to the Chart. You can even use declarative data source controls, like the SqlDataSource or ObjectDataSource controls.
</p><p>
In addition to converting your specified data points into a chart image, the Chart controls also include a wealth of statistical formulae that you can use to analyze the
plotted data. For example, with a single line of code you determine the mean (average) value for data in a particular series. Likewise, with one line of code you can get
the median, variance, or standard deviation. These values can be displayed as text on the page or as a <i>stripe line</i> on the chart itself. more, the Chart controls
include functions to forecast future values, to compute moving averages, to identify trends, and to determine rates of change, among others.
</p><p>
This article looks at how to use two statistical formulae. Specifically, look at how to compute and display the mean of a series, as well as how to display an exponential
trend line on the chart to forecast future values. Read on to learn more!
<br /><a More ></a></p>
Sponsored Links
Read Next: Using Transactions with SqlBulkCopy
Related Topics
Subscribe via RSS
SQL Server
- Naming Database Objects: Part II
- Trace Messages Part V: Trace Cleanup
- Naming Database Objects: Part I
- Multiple-Child Aggregation
- Creating SQL Tables for an Integrating Application Using Dexterity
- SQL Server 2005 Beta 2 Transact-SQL Enhancements
- .NET Rocks! - Brian Larson on SQL Server Reporting Services
- Computing the Trimmed Mean in SQL
- SQL Server 2000 Gains on Oracle
- Separator First Formatting (SFF)
