private void FrmMarkalar_Load(object sender, EventArgs e) { var degerler = db.TBLURUN.OrderBy(x => x.MARKA).GroupBy(y => y.MARKA). Select(z => new { Marka = z.Key, Toplam = z.Count() }); gridControl1.DataSource = degerler.ToList(); labelControl2.Text = db.TBLURUN.Count().ToString(); labelControl3.Text = (from x in db.TBLURUN select x.MARKA).Distinct().Count().ToString(); labelControl7.Text = (from x in db.TBLURUN orderby x.SATISFIYAT descending select x.MARKA).FirstOrDefault(); labelControl5.Text = db.maksurunmarka().FirstOrDefault(); // chartControl1.Series["Series 1"].Points.AddPoint("Bosch", 4); // chartControl1.Series["Series 1"].Points.AddPoint("Motip", 2); // chartControl1.Series["Series 1"].Points.AddPoint("MXS", 1); // 1. chart SqlConnection baglanti = new SqlConnection(@"Data Source=COMPUTERX\SQLEXPRESS;Initial Catalog=DbTeknikServis;Integrated Security=True"); baglanti.Open(); SqlCommand komut = new SqlCommand("SELECT MARKA, COUNT(*) FROM TBLURUN GROUP BY MARKA", baglanti); SqlDataReader dr = komut.ExecuteReader(); while (dr.Read()) { chartControl1.Series["Series 1"].Points.AddPoint(Convert.ToString(dr[0]), int.Parse(dr[1].ToString())); } baglanti.Close(); // 2. chart baglanti.Open(); SqlCommand komut2 = new SqlCommand("SELECT TBLKATEGORI.AD, COUNT(*) FROM TBLURUN INNER JOIN TBLKATEGORI ON TBLKATEGORI.ID = TBLURUN.KATEGORI GROUP BY TBLKATEGORI.AD", baglanti); SqlDataReader dr2 = komut.ExecuteReader(); while (dr2.Read()) { chartControl2.Series["Kategoriler"].Points.AddPoint(Convert.ToString(dr2[0]), int.Parse(dr2[1].ToString())); } baglanti.Close(); }