public DataTable bacaDataSemua()
{
classKoneksi = new koneksi();
sql = "select id_katalog,tipe_katalog,nama_katalog,tahun_terbit,harga_sewa from tbl_katalog left join tbl_tipe_katalog on tbl_katalog.id_tipe_katalog=tbl_tipe_katalog.id_tipe_katalog";
tabel = new DataTable();
try {
classKoneksi.bukaKoneksi();
komand = new OleDbCommand(sql);
adapter = new OleDbDataAdapter(sql, classKoneksi.dbase);
adapter.Fill(tabel);
} catch (Exception) {
MessageBox.Show("error");
}
return(tabel);
}
public DataTable bacaDataSemua()
{
classKoneksi = new koneksi();
sql = "select * from tbl_siswa";
tabel = new DataTable();
try {
classKoneksi.bukaKoneksi();
komand = new MySqlCommand(sql);
adapter = new MySqlDataAdapter(sql, classKoneksi.konek);
adapter.Fill(tabel);
} catch (Exception) {
MessageBox.Show("error");
}
return(tabel);
}
public DataTable updateData(int no_induk, string nama_siswa, string lahir, string alamat, string pass)
{
classKoneksi = new koneksi();
sql = "update tbl_siswa set nama_siswa='" + nama_siswa + "', kelahiran='" + lahir + "', alamat='" + alamat + "', password='******' where no_induk=" + no_induk + "";
tabel = new DataTable();
try {
classKoneksi.bukaKoneksi();
komand = new MySqlCommand(sql);
adapter = new MySqlDataAdapter(sql, classKoneksi.konek);
adapter.Fill(tabel);
} catch (Exception) {
MessageBox.Show("error");
}
return(tabel);
}
public DataTable tambahData(int no_induk, string nama_siswa, string lahir, string alamat, string pass)
{
classKoneksi = new koneksi();
sql = "insert into tbl_siswa (no_induk,nama_siswa,kelahiran,alamat,password) values (" + no_induk + ",'" + nama_siswa + "','" + lahir + "','" + alamat + "','" + pass + "')";
tabel = new DataTable();
try {
classKoneksi.bukaKoneksi();
komand = new MySqlCommand(sql);
adapter = new MySqlDataAdapter(sql, classKoneksi.konek);
adapter.Fill(tabel);
} catch (Exception) {
MessageBox.Show("error");
}
return(tabel);
}
public DataTable hapusDataSiswa(int no_induk)
{
classKoneksi = new koneksi();
sql = "delete from tbl_siswa where no_induk=" + no_induk + "";
tabel = new DataTable();
try {
classKoneksi.bukaKoneksi();
komand = new MySqlCommand(sql);
adapter = new MySqlDataAdapter(sql, classKoneksi.konek);
adapter.Fill(tabel);
MessageBox.Show("Berhasil");
} catch (Exception) {
MessageBox.Show("error");
}
return(tabel);
}
