How to bind a database with the chart series?

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" />