I would like to display data from my database in a chart.
I don't seem to be able to figure out how to get it working though!
I have tried the following code to bind the chart to my dataset but no joy!
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = ../SR.mdb" sql = "Select [ProdCell],[Competence] from Skills where EmpNo = " & UEmpNo & " Order By [ProdCell]" DSeS = ESDatCon.SelectData(sql, con) Chart1.Series(0).Points.DataBindXY(DSeS.Tables(0).Rows(0)("ProdCell"), DSeS.Tables(0).Rows(0)("Competence")) Chart1.Series(0).ChartType = DataVisualization.Charting.SeriesChartType.Doughnut
Am I working along the right lines or am I going about it completely wrong?
Thanks for any help/advice!