In this article I will explain with an example, how to create
Line Chart (Graph) in
Windows Forms (WinForms) Application using C# and VB.Net.
The
Line Chart (Graph) will be populated from
SQL Server database in
Windows Forms (WinForms) Application using C# and VB.Net.
Database
Here I am making use of Microsoft’s Northwind Database. You can download it from here.
The Chart control
The Chart control is present in the Data section of the Visual Studio ToolBox.
![Create Line Chart (Graph) in Windows Forms Application using C# and VB.Net]()
Form Design
The Form consists of a Chart control.
![Create Line Chart (Graph) in Windows Forms Application using C# and VB.Net]()
Namespaces
You will need to import the following namespaces.
C#
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Windows.Forms.DataVisualization.Charting;
VB.Net
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
Imports System.Windows.Forms.DataVisualization.Charting
Populating Line Chart from database in Windows Forms Application
Inside the Form Load event of the page, the Line Chart is populated from database.
The
SQL Query gets the
City-wise Order distribution and the records from database are populated into a
DataTable.
The names of the Cities are copied to the X array while the Order Totals for the corresponding cities are copied to the Y array.
Finally, the X and Y arrays are assigned to the Chart control.
C#
private void Form1_Load(object sender, EventArgs e)
{
//Fetch the Statistical data from database.
string query = "SELECT ShipCity, COUNT(OrderId) [Total]";
query += " FROM Orders WHEREShipCountry = 'Brazil'";
query += " GROUP BYShipCity";
DataTable dt = GetData(query);
//Get the names of Cities.
string[] x = (from p in dt.AsEnumerable()
orderby p.Field<string>("ShipCity")ascending
select p.Field<string>("ShipCity")).ToArray();
//Get the Total of Orders for each City.
int[] y = (from p in dt.AsEnumerable()
orderby p.Field<string>("ShipCity")ascending
select p.Field<int>("Total")).ToArray();
Chart1.Series[0].LegendText = "Brazil Order Statistics";
Chart1.Series[0].ChartType = SeriesChartType.Line;
Chart1.Series[0].BorderWidth = 3;
Chart1.Series[0].IsValueShownAsLabel = true;
Chart1.Series[0].Points.DataBindXY(x, y);
}
private static DataTable GetData(string query)
{
string constr = @"Data Source=.\SQL2019;Initial Catalog=Northwind;User ID= sa;Password=pass@123";
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlDataAdapter sda = new SqlDataAdapter(query, con))
{
DataTable dt = new DataTable();
sda.Fill(dt);
return dt;
}
}
}
VB.Net
Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
'Fetch the Statistical data from database.
Dim query As String = "SELECT ShipCity, COUNT(OrderId) [Total]"
query &= " FROM Orders WHEREShipCountry = 'Brazil'"
query &= " GROUP BYShipCity"
Dim dt As DataTable = GetData(query)
'Get the names of Cities.
Dim x As String() = (From p In dt.AsEnumerable() _
Order By p.Field(Of String)("ShipCity") _
Select p.Field(Of String)("ShipCity")).ToArray()
'Get the Total of Orders for each City.
Dim y As Integer() = (From p In dt.AsEnumerable() _
Order By p.Field(Of String)("ShipCity") _
Select p.Field(Of Integer)("Total")).ToArray()
Chart1.Series(0).LegendText = "Brazil Order Statistics"
Chart1.Series(0).ChartType = SeriesChartType.Line
Chart1.Series(0).BorderWidth = 3
Chart1.Series(0).IsValueShownAsLabel = True
Chart1.Series(0).Points.DataBindXY(x, y)
End Sub
Private Shared Function GetData(ByVal query As String) As DataTable
Dim constr As String = "Data Source= .\SQL2019;Initial Catalog=Northwind;User ID= sa;Password=pass@123"
Using con As SqlConnection = New SqlConnection(constr)
Using sda As SqlDataAdapter = New SqlDataAdapter(query, con)
Dim dt As DataTable = New DataTable()
sda.Fill(dt)
Return dt
End Using
End Using
End Function
Screenshot
![Create Line Chart (Graph) in Windows Forms Application using C# and VB.Net]()
Downloads
