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