private void tambahSubBidang() { BidangBagian bdg = new BidangBagian(); bdg.setBidang(textBoxSubBidangTambah.Text); string bidang = bdg.getBidang(); Database db = new Database(); string strconn = db.getString(); MySqlConnection conn = new MySqlConnection(strconn); conn.Open(); string query = "INSERT INTO sub_bagian_bidang VALUES(NULL, @id_bidang, @nama_sub_bagian_bidang)"; MySqlCommand cmd = new MySqlCommand(query, conn); cmd.Parameters.AddWithValue("@nama_sub_bagian_bidang", bidang); cmd.Parameters.AddWithValue("@id_bidang", id_bagian); int hasil = cmd.ExecuteNonQuery(); if (hasil > 0) { MessageBox.Show("Data berhasil ditambah", "Sukses"); frm1.getAllSubBidang(); } else { MessageBox.Show("Data gagal ditambah", "Gagal"); } conn.Close(); }
private void buttonEditSubBidang_Click(object sender, EventArgs e) { Database db = new Database(); string strconn = db.getString(); MySqlConnection conn = new MySqlConnection(strconn); conn.Open(); string query = "UPDATE sub_bagian_bidang SET nama_sub_bagian_bidang = @nama_sub_bagian_bidang WHERE id_sub_bagian_bidang = @id_sub_bagian_bidang"; MySqlCommand cmd = new MySqlCommand(query, conn); cmd.Parameters.AddWithValue("@id_sub_bagian_bidang", id_sub_bagian_bidang); cmd.Parameters.AddWithValue("@nama_sub_bagian_bidang", textBoxEditSubBidang.Text); //MessageBox.Show(query); int sukses = cmd.ExecuteNonQuery(); if (sukses > 0) { MessageBox.Show("Data berhasil diupdate", "Sukses"); frm1.getAllSubBidang(); } else { MessageBox.Show("Data gagal diupdate", "Gagal"); } conn.Close(); }