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