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";
}
