Dundas Chart for ASP.NET
ExportSeriesValues() Method
See Also  Example Send comments on this topic.
Dundas.Charting.WebControl Namespace > DataManipulator Class > ExportSeriesValues Method : ExportSeriesValues() Method


Enterprise Edition Only Feature. Exports the data for every series stored in the Series collection to a DataSet object.


Export all series from the collection into the DataSet object.

Syntax

Visual Basic (Declaration)  
Public Overloads Function ExportSeriesValues() As DataSet
Visual Basic (Usage) Copy Code
Dim instance As DataManipulator
Dim value As DataSet
 
value = instance.ExportSeriesValues()
C#  
public DataSet ExportSeriesValues()

Return Value

A DataSet object that stores all chart series as DataTable objects. Each data point is stored as a DataRow object.


Data set object with series data.

Example

This example demonstrates how to export all chart series to a DataSet object.  We assume that a chart has been added at design-time.
Visual Basic Copy Code
Imports Dundas.Charting.WebControl<CRLF> ...<CRLF><CRLF>'export all series in the chart's Series collection<CRLF>Dim allSeriesData As DataSet = Chart1.DataManipulator.ExportSeriesValues()
C# Copy Code
using Dundas.Charting.WebControl;<CRLF>  ...<CRLF><CRLF>// export all series in the chart's Series collection<CRLF>Dim allSeriesData As DataSet = Chart1.DataManipulator.ExportSeriesValues();

Remarks

Exports the data for all series in the Series collection as a returned DataSet object. A DataTable object is created for each chart series and is added to the Tables collection of the DataSet (each DataTable object will have the same name as the series it represents).

Every data point in a series is stored as a DataRow object that is inserted into the Rows collection of the applicable DataTable object.

Each DataTable object will have two or more columns (represented by DataColumn objects): one column for the Y-value of data points and one column per Y-value. All DataColumn objects are named for the value that they represent (e.g. "X", "Y", "Y2", etc.). The column types depends on each Series object's XValueType and YValueType properties. DateTime value types are stored as DateTime columns, String value types are stored as String columns, and all other types are stored as Double columns. Note that a String value type can only be used for the X-values of a chart's data points, and if this is the case it is the AxisLabel property of each data point that determines the stored value.

Empty points by default are not exported. To export empty data points set the IgnoreEmptyPoints property to false (these points will then be stored as DBNull objects in the DataRow object).

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

Copyright © 2001 - 2009 Dundas Data Visualization, Inc. and others.