Hi Kumar,
Thank you for reaching out to us. We have analyzed your query and found
that we can bind a data table to the ItemSource of the pivot chart is
possible by inheriting DataView. The following code snippet demonstrates
how to inherit the DataView class, which connects the view to its corresponding
DataTable, to bind the data table to the pivot chart.
pivotChart1.ItemSource =
ProductSalesObjectsDataView.GetDataTable();
|
The sample file also includes a DataTable collection view code
snippet that demonstrates how to create the DataTable and add the data to it.
public class ProductSalesObjectsDataView : DataView
{
public static DataView GetDataTable()
{
DataTable dataTable = new DataTable("ProductSalesObjectsDataView");
PropertyDescriptorCollection
propertyDescriptorCollection = TypeDescriptor.GetProperties(typeof(ProductSales));
foreach (PropertyDescriptor propertyDescriptor in propertyDescriptorCollection)
{
dataTable.Columns.Add(new DataColumn(propertyDescriptor.Name,
propertyDescriptor.PropertyType));
}
ProductSalesCollection
productSalesObjectCollection = ProductSales.GetSalesData();
foreach (ProductSales businessObject in productSalesObjectCollection)
{
DataRow dataRow =
dataTable.NewRow();
foreach (PropertyDescriptor
propertyDescriptor in
propertyDescriptorCollection)
{
dataRow[propertyDescriptor.Name] =
propertyDescriptor.GetValue(businessObject);
}
dataTable.Rows.Add(dataRow);
}
return dataTable.DefaultView;
}
}
|
Please refer to the following documentation for more information
on data binding the pivot chart.
https://help.syncfusion.com/windowsforms/pivot-chart/getting-started#binding-data
https://help.syncfusion.com/windowsforms/pivot-grid/data-binding#binding-data-from-data-table
Please let me know if you have any further assistance. We
are here to help.
Regards,
Nanthini Mahalingam.
Attachment:
SF180015_ac300eb1.zip