Display chart in WPF

Question

Hi I wantu display chart in WPF based on my MYSQL data. Can anyone please help me. Thanks in advance. Regards Shwetha

Shwetha Dali · Answer

Dictionary dic = (from order in dt.AsEnumerable() select new { //Get the specific Field from the datatable. company = order.Field (asdf) product = order.Field (toc) }).AsEnumerable().ToDictionary(k => k.company v => v.product); //// ((ColumnSeries)mcChart.Series[0]).ItemsSource = dic; ((ColumnSeries)mcChart.Series[0]).ItemsSource =dic; I saw the articlesI'm able to store the data in datable and i'm converting it into key value pair. But still i'm getting error Value cannot be null. but there are values in 'dic'. Thanks Shwetha

Mahesh Chand · Answer

Did you see the recommended articles? Charting has two parts. First you must get data from MySQL and format the way you want to display the chart. charts need data collection in a certain format. See my articles below. Once you have that format you will need to bind that collection with the chart and chart will display it.