print

public form 1
 chart1.ChartAreas[0].AxisX.Interval = 0.5;



 private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {

            string constring = "datasource=localhost;port=3306;username=root;password=admin";
            string Query = "select * from project.gemeentemisdrijven where Gemeenten = '" + comboBox1.Text + "' LIMIT 0, 1";
            MySqlConnection conDataBase = new MySqlConnection(constring);
            MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
            MySqlDataReader myReader;

            try
            {
                conDataBase.Open();
                myReader = cmdDataBase.ExecuteReader();
                if (myReader.HasRows)
                {
                    List<int> yValues = new List<int>();
                    int count = myReader.FieldCount;
                    while (myReader.Read())
                    {

                        for (int i = 1; i <19; i++)
                        {
                            yValues.Add(Int32.Parse(myReader.GetString(i)));
                            Console.WriteLine(myReader.GetValue(i));
                        }


                    }

                    string[] xValues = {"Bedreigingen","Brand/ontploffingen", "Diefstal van motorvoertuigen", "Diefstal uit/vanaf motorvoertuigen", "Diefstal/inbraak bedrijven/instellingen", "Diefstal/inbraak garage/schuur/tuinhuis", "Drugshandel", "HIC: Diefstal/inbraak woning, voltooid", "HIC: Diefstal/inbraak woning, pogingen", "HIC: Geweldsmisdrijven", "HIC: Straatroof", "HIC: Overvallen", "Huisvredebreuk","Huisvredebreuk",
"Mishandeling","Openlijk geweld (persoon)","Vernieling cq. zaakbeschadiging","Wapenhandel" };
                    chart1.Series[0].Points.DataBindXY(xValues, yValues);
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }




        }

 private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
        {

            string constring = "datasource=localhost;port=3306;username=root;password=admin";
            string Query = "select * from project.gemeentemisdrijven where Gemeenten = '" + comboBox2.Text + "' LIMIT 0, 1";
            MySqlConnection conDataBase = new MySqlConnection(constring);
            MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
            MySqlDataReader myReader;

            try
            {
                conDataBase.Open();
                myReader = cmdDataBase.ExecuteReader();
                if (myReader.HasRows)
                {
                    List<int> yValues = new List<int>();
                    int count = myReader.FieldCount;
                    while (myReader.Read())
                    {

                        for (int i = 1; i < 19; i++)
                        {
                            yValues.Add(Int32.Parse(myReader.GetString(i)));
                            Console.WriteLine(myReader.GetValue(i));
                        }


                    }

                    string[] xValues = {"Bedreigingen","Brand/ontploffingen", "Diefstal van motorvoertuigen", "Diefstal uit/vanaf motorvoertuigen", "Diefstal/inbraak bedrijven/instellingen", "Diefstal/inbraak garage/schuur/tuinhuis", "Drugshandel", "HIC: Diefstal/inbraak woning, voltooid", "HIC: Diefstal/inbraak woning, pogingen", "HIC: Geweldsmisdrijven", "HIC: Straatroof", "HIC: Overvallen", "Huisvredebreuk","Huisvredebreuk",
"Mishandeling","Openlijk geweld (persoon)","Vernieling cq. zaakbeschadiging","Wapenhandel" };
                    chart1.Series[1].Points.DataBindXY(xValues, yValues);
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }