Spread Windows Forms 9.0 Product Documentation > Developer's Guide > Working with the Chart Control > Creating Charts > Connecting to Data > Using a Bound Data Source |
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).
Create a data source and then bind the control.
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 |
Create a data source and then bind the control.
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 |