Loading Datagrid view data into Live Chart for C# form app

I am using Live chart for the first time in a C# form application. I have a data grid view (datagridview1). It has two columns. Date and Price. I am trying to make a cartesian diagram based on these two values. I dunno how to use the data grid view column values in the chart. Any suggestions, please!

cartesianChart1.Series = new SeriesCollection
{
new LineSeries
{
Title = "Date Vs Price",
},
};
cartesianChart1.AxisX.Add(new Axis
{
Title = "Date",
//values-- how to get Date values here
});
cartesianChart1.AxisY.Add(new Axis
{
Title = "Price",
//values-- how to get price values here
});

//My data is in the following format
|Date |Price |
|2020-01-27 09:42:38 |100 |
|2020-01-27 09:43:38 |200 |
|2020-01-27 09:44:38 |220 |

I am trying to draw a cartesian graph--> Date Vs. Price. Any suggestion to load these data into the live chart from Datagrid view?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Daya Daya6y ago
Hi
Surya Kant.

My doubt is about using Live Charts https://lvcharts.net/
0
Surya Kant6y ago
Hi Daya,
As i understnad you wants to connect the point and draw a cartesians graph, if that is the case then below link will help you,
https://stackoverflow.com/questions/4997537/how-do-i-plot-cartesian-points-in-a-winforms-project

Thanks,
Sk.
0

Loading Datagrid view data into Live Chart for C# form app

Surya Kant.