private void button4_Click(object sender, EventArgs e)
{
koneksi conn = new koneksi();
conn.tampil();
conn.QUERY("delete from sewa where id='" + id.Text + "'");
MessageBox.Show("delete data success");
}
private void button3_Click(object sender, EventArgs e)
{
koneksi conn = new koneksi();
conn.tampil();
conn.QUERY("update sewa set nama='" + this.nama.Text + "',jenkel='" +
jenkel.Text + "',napac='" + napac.Text + "',alasan='" + alasan.Text + "'");
MessageBox.Show("Update data success");
int hasil, a, b;
a = Convert.ToInt16(lama.Text);
b = Convert.ToInt16(honor.Text);
hasil = a * b;
total.Text = hasil.ToString();
}
private void button2_Click(object sender, EventArgs e)
{
koneksi conn = new koneksi();
conn.tampil();
conn.QUERY("insert into sewa (nama,jenkel,napac,alasan) values ('"
+ this.nama.Text + "', '" + this.jenkel.Text + "', '" + this.napac.Text + "', '" + this.alasan.Text
+ "')");
MessageBox.Show("insert data success");
int hasil, a, b;
a = Convert.ToInt16(lama.Text);
b = Convert.ToInt16(honor.Text);
hasil = a * b;
total.Text = hasil.ToString();
}
public DataTable baca()
{
koneksi conn = new koneksi();
string sql = "select * from sewa";
DataTable dt = new DataTable();
try
{
conn.tampil();
MySqlCommand cmd = new MySqlCommand(sql, conn.konek);
MySqlDataAdapter adp = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
adp.Fill(dt);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
conn.tutup();
return(dt);
}
