public DataTable GetAll() { string query = "SELECT nip,namaguru,jabatan FROM guru"; AccesDB dd = new AccesDB(); return(dd.GetData(query)); }
public void Hapus(string nip) { string query = "DELETE FROM guru WHERE nip=@kriteria"; AccesDB dd = new AccesDB(); dd.Execute(query, new OleDbParameter("@kriteria", nip)); }
public DataTable GetByName(string namaguru) { string query = "SELECT nip,namaguru,jabatan FROM guru WHERE namaguru LIKE @kriteria"; AccesDB dd = new AccesDB(); return(dd.GetData(query, new OleDbParameter("@kriteria", "%" + namaguru + "%"))); }
public void Add(gurumodel data) { string query = "INSERT INTO guru (nip,namaguru,jabatan) VALUES (@nip,@namaguru,@jabatan)"; AccesDB dd = new AccesDB(); dd.Execute(query, new OleDbParameter("@nip", data.nip), new OleDbParameter("@namaguru", data.namaguru), new OleDbParameter("@jabatan", data.jabatan)); }
public void Edit(string nip, gurumodel data) { string query = "UPDATE guru SET nip=@nipbaru,namaguru=@namagurubaru WHERE nip=@nipLama"; AccesDB dd = new AccesDB(); dd.Execute(query, new OleDbParameter("@nisBaru", data.nip), new OleDbParameter("@namaBaru", data.namaguru), new OleDbParameter("@kelasBaru", data.jabatan), new OleDbParameter("@nisLama", nip)); }
public gurumodel GetByNip(string nip) { gurumodel data = null; string query = "SELECT nip,namaguru,jabatan FROM guru WHERE nip=@kriteria"; AccesDB dd = new AccesDB(); DataTable dtguru = dd.GetData(query, new OleDbParameter("@kriteria", nip)); if (dtguru.Rows.Count == 1) { //ambil satu baris saja DataRow row = dtguru.Rows[0]; //masukkan ke model siswa data = new gurumodel(); data.nip = row["nip"].ToString(); data.namaguru = row["namaguru"].ToString(); data.jabatan = row["jabatan"].ToString(); } return(data); }
public siswamodel GetByNis(string nis) { siswamodel data = null; string query = "SELECT nis,nama,kelas FROM siswa WHERE nis=@kriteria"; AccesDB db = new AccesDB(); DataTable dtSiswa = db.GetData(query, new OleDbParameter("@kriteria", nis)); if (dtSiswa.Rows.Count == 1) { //ambil satu baris saja DataRow row = dtSiswa.Rows[0]; //masukkan ke model siswa data = new siswamodel(); data.nis = row["nis"].ToString(); data.nama = row["nama"].ToString(); data.kelas = row["kelas"].ToString(); } return(data); }