Retrieving Chart Data from a Database

With MindFusion.Charting you can retrieve database fields and set them as data for the chart labels and numerical values. You can bind the database fields directly to the properties, which the control provides. Please, refer to Chart Members, AxesChart Members, BarChart Members, PieChart Members, RadarChart Members and LineChart Members lists for more information exactly which these properties are. You will recognize them by the suffix "field(s)" added to the name of the property.

When using MindFusion.Charting programmatically you can do data binding manually, so no special properties are needed and therefore provided in order to set data from a database to the chart properties.

When you start binding database fields to chart properties the first thing to do is provide a valid DataSource object. If it is of type DataSet, specify the name of the table with the data you need in the DataMember property. When you have finished with all this, then you can start assigning database fields to the chart's properties.

When using MindFusion.Charting.WebForms at design time with VisualStudio 2005, the DataSource object is replaced by the DataSourceID property. Use DataSource when you make databinding programmatically at run time.

The subtopics show step by step how you can bind database controls from Microsoft VisualStudio 2008 or VisualStudio 2005 development environments to MindFusion.Charting database properties.

See Also