public override void Sil(object obj)
{
alinandersler alinan = (alinandersler)obj;
Baglan();
komut = new SqlCommand("alinanSil", baglanti);
komut.CommandType = CommandType.StoredProcedure;
komut.Parameters.AddWithValue("@O_id", alinan.O_id);
komut.ExecuteNonQuery();
baglanti.Close();
baglanti.Dispose();
}
public override DataTable Listele(object obj)
{
alinandersler alinan = (alinandersler)obj;
Baglan();
string sorgu = "select o.Adi,d.Adi,og.Adi from tbl_alinanDersler al,tbl_dersler d,tbl_ogrenci o,tbl_ogretmen og where al.D_id = d.id and al.O_id = o.id and al.Og_id = og.id and o.id = '" + alinan.O_id;
komut = new SqlCommand(sorgu, baglanti);
komut.CommandType = CommandType.Text;
komut.ExecuteNonQuery();
adaptor = new SqlDataAdapter(komut);
tablo = new DataTable();
adaptor.Fill(tablo);
baglanti.Close();
baglanti.Dispose();
return(tablo);
}
