예제 #1
0
파일: frm_Index.cs 프로젝트: sule-mese/UBYS
        private void btn_Devamsızlık_Click(object sender, EventArgs e)
        {
            frm_Devam_Index frm3 = new frm_Devam_Index();

            frm3.ShowDialog();
            frm3.Close();
        }
예제 #2
0
        private void frm_Devam_Ekle_FormClosed(object sender, FormClosedEventArgs e)
        {
            this.Close();
            this.Hide();
            frm_Devam_Index frm = (frm_Devam_Index)Application.OpenForms["frm_Devam_Index"];

            str = @"SELECT Ogrenci_Ders.Ogr_Ders_ID AS 'ID',
                           Ogrenci_Kaydi.No AS 'Ogr No',
                           Ogrenci_Kaydi.AdSoyad AS 'Ad Soyad',
                           Ders_Bilgi.DersNo AS 'Ders Kodu',
                           Ders_Bilgi.DersAdi AS 'Ders Adı',
                           Ders_Bilgi.DersHoca AS 'Öğretim Görevlisi',
                           Ogrenci_Ders.DersToplam AS 'Toplam Ders',
                           Ogrenci_Ders.DersDevamsiz AS 'Devamsız'
                           FROM Ogrenci_Ders
                           INNER JOIN Ogrenci_Kaydi ON Ogrenci_Ders.Ogr_ID = Ogrenci_Kaydi.Ogr_ID
                           INNER JOIN Ders_Bilgi ON Ders_Bilgi.Ders_ID = Ogrenci_Ders.Ders_ID";
            frm.dataGridView1.DataSource = DBLayer.TabloSorgula(str);
        }