1-) C# - sql veritabanında verilerin istatistiklerini charta ekleme

SqlConnection baglanti = new SqlConnection("Data Source=DESKTOP-OVO6QPR;Initial Catalog=PersonelVeriTabani;Integrated Security=True");

        private void frmgrafikler_Load(object sender, EventArgs e)

        {

            baglanti.Open();

            SqlCommand komutg1 = new SqlCommand("Select PerSehir,Count(*) From Tbl_Personel group By PerSehir",baglanti);

            SqlDataReader dr1 = komutg1.ExecuteReader();

            while (dr1.Read())

            {

                chart1.Series["Sehirler"].Points.AddXY(dr1[0], dr1[1]);

            }

            baglanti.Close();

            baglanti.Open();

            SqlCommand komutg2 = new SqlCommand("Select PerMeslek,Avg(PerMaas) From Tbl_Personel group by Permeslek",baglanti);

            SqlDataReader dr2 = komutg2.ExecuteReader();

            while (dr2.Read())

            {

                chart2.Series["Meslek-Maas"].Points.AddXY(dr2[0],dr2[1]);

            }

            baglanti.Close();

        }