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