Windows Forms: How to Link Chart /Graph with Database in C#
By FoxLearn 6/6/2017 9:15:06 PM 15.79K
How to Link Chart/Graph with Local Database in C# using DataBinding
Step 1: Click New Project, then select Visual C# on the left, then Windows and then select Windows Forms Application. Name your project "ChartDemo" and then click OK
Step 2: Create a local database, then add a AgeStatistic table to your database -> create a dataset then drag the AgeStatistic table to your dataset as below
Step 3: Design your form as below
Step 4: Add code to handle your form as below
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace ChartDemo { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'database.AgeStatistics' table. You can move, or remove it, as needed. this.ageStatisticsTableAdapter.Fill(this.database.AgeStatistics); } private void btnSave_Click(object sender, EventArgs e) { try { //Update data to sql database ageStatisticsBindingSource.EndEdit(); ageStatisticsTableAdapter.Update(database.AgeStatistics); MessageBox.Show("Your data has been successfully saved.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch(Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } private void btnLoad_Click(object sender, EventArgs e) { //Load data to chart/graph chart1.Series["Age"].XValueMember = "Age"; chart1.Series["Age"].YValueMembers = "Total"; chart1.DataSource = database.AgeStatistics; chart1.DataBind(); } } }
VIDEO TUTORIALS
- How to make a Notepad in C#
- How to Receive SMS from WhatsApp in C#
- How to Add Combobox to DataGridView in C#
- How to Create Multiple pages on the Form using Panel control in C#
- How to insert Math Equation to RichTextBox in C#
- How to Send and Receive email in Microsoft Outlook using C#
- How to Print Windows Form in C#
- How to Use Form Load and Button click Event in C#
Categories
Popular Posts
How to sign a powershell script
10/03/2024
How to get Credentials in PowerShell?
10/03/2024
How to implement Jint in C#
09/14/2024