Spread Windows Forms 6.0 Product Documentation
Using a Bound Data Source
Support Options
Spread Windows Forms 6.0 Product Documentation > Developer's Guide > Working with the Chart Control > Creating Charts > Connecting to Data > Using a Bound Data Source

Glossary Item Box

You can bind the chart to the following data sources:

When the chart is bound to data, it dynamically plots the data when it paints. A single chart can support (and display) data from multiple data sources and multiple data fields within a data source. For more information about the DataSource property, refer to the specific chart type in the Assembly Reference (for example: SeriesNameDataSource in the RadarLineSeries class).

Using Code

Create a data source and then bind the control.

Example

The following example demonstrates how to bind the control to a data source.

C# Copy Code
// Create an array and bind the control
 
object[] values = new object[] { 2, 4.0, 3.0m, "5.0" };
 
BarSeries series = new BarSeries();
 
series.Values.DataSource = values;
 
VB Copy Code
' Create an array and bind the control
 
Dim values() As Object = {2, 4.0, 3.0D, "5.0"}
 
Dim series As New BarSeries()
 
series.Values.DataSource = values
 

Using Code

Create a data source and then bind the control.

Example

The following example demonstrates how to bind the control to a data table.

C# Copy Code
DataTable dt = new DataTable("Test");
 
DataRow dr = default(DataRow);
 
dt.Columns.Add("Series0");
 
dt.Columns.Add("Series1");
 
dr = dt.NewRow();
 
dr[0] = 2;
 
dr[1] = 1;
 
dt.Rows.Add(dr);
 
dr = dt.NewRow();
 
dr[0] = 4;
 
dr[1] = 2;
 
dt.Rows.Add(dr);
 
dr = dt.NewRow();
 
dr[0] = 3;
 
dr[1] = 4;
 
FarPoint.Win.Chart.BarSeries series = new FarPoint.Win.Chart.BarSeries();
 
series.Values.DataSource = dt;
 
series.Values.DataField = dt.Columns[0].ColumnName;
 
FarPoint.Win.Chart.YPlotArea plotArea = new FarPoint.Win.Chart.YPlotArea();
 
FarPoint.Win.Chart.ChartModel model = new FarPoint.Win.Chart.ChartModel();
 
plotArea.Location = new PointF(0.2F, 0.2F);
 
plotArea.Size = new SizeF(0.6F, 0.6F);
 
plotArea.Series.Add(series);
 
model.PlotAreas.Add(plotArea);
 
fpChart1.Model = model;
 
VB Copy Code
Dim dt As New DataTable("Test")
 
Dim dr As DataRow
 
dt.Columns.Add("Series0")
 
dt.Columns.Add("Series1")
 
dr = dt.NewRow()
 
dr(0) = 2
 
dr(1) = 1
 
dt.Rows.Add(dr)
 
dr = dt.NewRow()
 
dr(0) = 4
 
dr(1) = 2
 
dt.Rows.Add(dr)
 
dr = dt.NewRow()
 
dr(0) = 3
 
dr(1) = 4
 
dt.Rows.Add(dr)
 
Dim series As New FarPoint.Win.Chart.BarSeries
 
series.Values.DataSource = dt
 
series.Values.DataField = dt.Columns(0).ColumnName
 
Dim model As New FarPoint.Win.Chart.ChartModel()
 
Dim plotArea As New FarPoint.Win.Chart.YPlotArea()
 
plotArea.Location = New PointF(0.2F, 0.2F)
 
plotArea.Size = New SizeF(0.6F, 0.6F)
 
plotArea.Series.Add(series)
 
model.PlotAreas.Add(plotArea)
 
FpChart1.Model = model
 

Return to Connecting to Data.

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.