Category / Section
How to bind a database with the chart series?
1 min read
A data base can be bound to the chart series using a dataset. Fill the data in the data table of a dataset. Add the dataset to a resource, and then bind the Data property of the ChartSeries to the created resource.
The following code fills the dataset and creates a resource with the name of MyDBSource.
C#
//Fill the dataset
DataAdapter.Fill(dataset, "Product");
//Creating resource with the name MyDBSource
this.Resources.Add("MyDBSource", dataset.Tables["Product"].Rows);
The following code snippet is used to bind the data to chart series.
XAML
<syncfusion:ChartSeries Name="Series1" Data="{syncfusion:ChartBindingData Source={StaticResource MyDBSource},XPath=ProductID, YPaths=UnitsInStock}" Type ="Column" />