public DataTable GetAll() { string query = "SELECT nis,nama,kelas FROM siswa"; MySQLDB db = new MySQLDB(); return(db.GetData(query)); }
public DataTable GetByName(string nama) { string query = "SELECT nis,nama,kelas FROM siswa WHERE nama LIKE @kriteria"; MySQLDB db = new MySQLDB(); return(db.GetData(query, new Dictionary <string, dynamic>() { { "@kriteria", "%" + nama + "%" } })); }
public SiswaModel GetByNis(string nis) { SiswaModel data = null; string query = "SELECT nis,nama,kelas FROM siswa WHERE nis=@kriteria"; MySQLDB db = new MySQLDB(); DataTable dtSiswa = db.GetData(query, new Dictionary <string, dynamic>() { { "@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); }