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