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 cariBidang() { BidangBagian namaBidang = new BidangBagian(); string cari = textBoxCariBidang.Text; Database db = new Database(); string strconn = db.getString(); MySqlConnection conn = new MySqlConnection(strconn); conn.Open(); string query = "SELECT * FROM bagian_bidang WHERE nama_bagian_bidang LIKE '%" + cari + "%'"; //MessageBox.Show(query); MySqlCommand cmd = new MySqlCommand(query, conn); cmd.Parameters.AddWithValue("@cari", cari); MySqlDataReader reader = cmd.ExecuteReader(); setDataTable(reader); conn.Close(); }