コード例 #1
0
ファイル: frm_Index.cs プロジェクト: sule-mese/UBYS
        private void btn_Ogr_Ders_Click(object sender, EventArgs e)
        {
            frm_Ogr_Ders_Index frm5 = new frm_Ogr_Ders_Index();

            frm5.ShowDialog();
            frm5.Close();
        }
コード例 #2
0
        private void frm_Ogr_Ders_Ekle_FormClosed(object sender, FormClosedEventArgs e)
        {
            this.Close();
            this.Hide();
            frm_Ogr_Ders_Index frm = (frm_Ogr_Ders_Index)Application.OpenForms["frm_Ogr_Ders_Index"];

            str = @"SELECT Ogrenci_Kaydi.No AS 'Ogr. No',
                    Ogrenci_Kaydi.AdSoyad AS 'Ad Soyad',
                    Ders_Bilgi.DersNo AS 'Ders Kodu',
                    Ders_Bilgi.DersAdi AS 'Ders Adi',
                    Ders_Bilgi.DersHoca AS 'Öğretim Görevlisi'
                    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);
        }