Graphical Report in Windows Application Using Chart Control

In Visual Studio 2010, Microsoft added a Chart Control to show data in graphical format. Using a Chart Control you can very simply show complex statistical data.

In this example I will implement a Chart Control in a Windows application.

Step 1 : Create an Employee table and add some data for the report.

Step 2 : Now, create a new Windows Forms Application.

Step 3 : Drag and drop the Chart Control to the form as shown in the screen below.

Step 4 : Add the following code to the form.

Namespace

using System.Data.SqlClient;

using System.Web.UI.DataVisualization.Charting;

Code On Form Load Event

SqlConnection conn = new SqlConnection("Server=LENOVO-PC;Database=Abhinav;User Id=sa;Password=****");

string qry = "select Name, Salary from employee";

SqlDataAdapter da = new SqlDataAdapter(qry, conn);

DataSet ds = new DataSet();

da.Fill(ds,"Salary");

chart1.DataSource = ds.Tables["Salary"];

chart1.Series["Series1"].XValueMember = "NAME";

chart1.Series["Series1"].YValueMembers = "SALARY";

this.chart1.Titles.Add("EMPLOYEE SALARY"); // Set the chart title

chart1.Series["Series1"].ChartType = SeriesChartType.Pie; // Set chart type like Bar chart, Pie chart

chart1.Series["Series1"].IsValueShownAsLabel = true; // To show chart value

On Button Click to Save Chart

this.chart1.SaveImage("D:\\chart1.Jpeg", ChartImageFormat.Jpeg);

MessageBox.Show("Chart Saved Successfully", Application.ProductName,
MessageBoxButtons.OK, MessageBoxIcon.Information);

Step 5 : Now run the application, you will see a graphical report like this.

You can download the complete attached source code.

I hope you liked it.