public DataTable KayitKontrol(OgrenciDersInfo ogrenciDersBilgi)
{
string sql = "SELECT * FROM ogrenciDers WHERE (idx=@Idx and ders=@Ders);";
OleDbParameter[] par = new OleDbParameter[] {
new OleDbParameter("@Idx", OleDbType.Integer),
new OleDbParameter("@Ders", OleDbType.Integer)
};
par[0].Value = ogrenciDersBilgi.Idx;
par[1].Value = ogrenciDersBilgi.Ders;
return(helper.ExecuteDataSet(sql, par).Tables[0]);
}
public int KayitEkle(OgrenciDersInfo ogrenciDersBilgi)
{
string sql = "insert into ogrenciDers (idx, ders, adi) Values (@Idx, @Ders, @Adi)";
OleDbParameter[] par = new OleDbParameter[] {
new OleDbParameter("@Idx", OleDbType.Integer),
new OleDbParameter("@Ders", OleDbType.Integer),
new OleDbParameter("@Adi", OleDbType.VarChar, 100)
};
par[0].Value = ogrenciDersBilgi.Idx;
par[1].Value = ogrenciDersBilgi.Ders;
par[2].Value = ogrenciDersBilgi.Adi;
return(helper.ExecuteNonQuery(sql, par));
}
