How to Link Chart Graph With Database in Windows Forms

Here I will explain how to connect a Chart-Graph with a database.

Step 1: Form

Drag and drop a chart graph and a button from the tool box.

Step 2: Coding

Now click on the Button (Load Button). and write this code:

private void Load_button_Click(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("server = MUNESH;Database=datastore;UID=sa;Password=123;");

SqlCommand cmd = new SqlCommand("Select * from data1", con);

DataReader mydatareader ;

try

{

con.Open();

myreader = cmd.ExecuteReader();

while(myreader.Read())

{

this.chart1.Series["Age"].Points.AddXY(myreader.GetString("name"),myreader.GetInt32("Age"));

}

}

Catch(Exception ex)

{

MessageBox.show(ex.message);

}

}

Step 3: Run

Now run your application and click on the button.

You can go to my blog_munesh