1-) C# - 89. Grafiğe Veri Tabanından Veri

using System;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace Personel_kayit

{

    public partial class frmgrafikler : Form

    {

        public frmgrafikler()

        {

            InitializeComponent();

        }

        SqlConnection baglanti = new SqlConnection("Data Source=DESKTOP-9BC05PL;Initial Catalog=PersonelVeriTabani;User Id=sa;Password=123456;Integrated Security=True");//kopyalanmış databaseyi yapıştırıyoruz.

        private void frmgrafikler_Load(object sender, EventArgs e)

        {

            //grafik 1

            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();

            //grafik 2

            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();

        }

    }

}

frmAnaFrom.cs

        private void BtnGrafikler_Click(object sender, EventArgs e)

        {

            frmgrafikler frg = new frmgrafikler();

            frg.Show();

        }