How to implement a pie chart or bar diagram from a data table column after execution of SQL query in C#

See more:

C#

SQL

DataGridView

DataTable

, +

Hi,

I have developed an application which will retrieve data from a SQL table. The table will have two columns. One column is a number and another one is the time. In the first column i can have same number repeated number of times.

When i execute the program, the table data is displaying in the datagrid view in a c# windows form.

Now My requirement is when i press a button,the data in the first column should be displayed in a pie chart or bar diagram based on the repeatition of the value in the column.

For example, in the first column i have 400 number for 8 times and 300 number for 2 times. SO when i click a button it should be displayed in a diagram like 400 is 80% and 300 is 20 %.

Data table example is like below link:-

Datagrid — imgbb.com[^]

What I have tried:

My code to retrieve the data and display in datagridview is as like below:-

conn.Open();
cmd = new SqlCommand(sql, conn);
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable dt = new DataTable();
adapter.SelectCommand = cmd;
adapter.Fill(dt);
cmd.Dispose();
conn.Close();
dataGridView1.DataSource = dt;