private void btn_Kaydet_Click(object sender, EventArgs e) { str = @"UPDATE Ogrenci_Ders SET Ders_ID = '" + ID.ToString() + @"' FROM Ogrenci_Kaydi OK Inner Join Ogrenci_Ders OD ON OK.Ogr_ID = OD.Ogr_ID Inner Join Ders_Bilgi DB ON OD.Ders_ID = DB.Ders_ID WHERE OK.No = '" + textBox1.Text + @"' AND DB.DersNo = '" + DERSNO.ToString() + "'"; DBLayer.IslemYap(str); str = @"UPDATE Ogrenci_Not SET Ders_ID = '" + ID.ToString() + @"' FROM Ogrenci_Kaydi OK Inner Join Ogrenci_Not OgN ON OK.Ogr_ID = OgN.Ogr_ID Inner Join Ders_Bilgi DB ON OgN.Ders_ID = DB.Ders_ID WHERE OK.No = '" + textBox1.Text + @"' AND DB.DersNo = '" + DERSNO.ToString() + "'"; DBLayer.IslemYap(str); ID = "0"; DERSNO = "0"; 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"; dataGridView1.DataSource = DBLayer.TabloSorgula(str); }
private void btn_Devam_Sil_Click(object sender, EventArgs e) { str = @"Update Ogrenci_Ders SET DersToplam = NULL, DersDevamsiz = NULL FROM Ogrenci_Kaydi OK Inner Join Ogrenci_Ders OD ON OK.Ogr_ID = OD.Ogr_ID Inner Join Ders_Bilgi DB ON OD.Ders_ID = DB.Ders_ID WHERE OK.No = '" + ID.ToString() + @"' and DB.DersNo = '" + DERSNO.ToString() + "'"; DBLayer.IslemYap(str); 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"; dataGridView1.DataSource = DBLayer.TabloSorgula(str); ID = "0"; DERSNO = "0"; }