private void button4_Click(object sender, EventArgs e) { string x = ""; string tl = ""; if (ckbHD.Checked == true) { tl = tl + "hanh dong, "; x = x + " hanhdong = 'True',"; } else { x = x + " hanhdong = 'False',"; } if (ckbNL.Checked == true) { tl = tl + "nguoi lon, "; x = x + " nguoilon = 'True',"; } else { x = x + "nguoilon = 'False',"; } if (ckbPL.Checked == true) { tl = tl + "phieu lieu, "; x = x + " phieuluu = 'True',"; } else { x = x + " phieuluu 'False',"; } if (ckbHH.Checked == true) { tl = tl + "hai huoc, "; x = x + " haihuoc = 'True',"; } else { x = x + " haihuoc = 'False',"; } if (ckbDrama.Checked == true) { tl = tl + "drama, "; x = x + " drama = 'True',"; } else { x = x + " drama = 'False',"; } if (ckbFan.Checked == true) { tl = tl + "fantasy, "; x = x + " fantasy = 'True',"; } else { x = x + " fantasy = 'False',"; } if (ckbLS.Checked == true) { tl = tl + "lich su, "; x = x + " lichsu = 'True',"; } else { x = x + " lichsu = 'False',"; } if (ckbCG.Checked == true) { tl = tl + "con gai, "; x = x + " congai ='True',"; } else { x = x + " congai = 'False',"; } if (ckbCT.Checked == true) { tl = tl + "contrai, "; x = x + " contrai = 'True',"; } else { x = x + " contrai = 'False',"; } if (ckbKDi.Checked == true) { tl = tl + "kinh di, "; x = x + " kinhdi = 'True',"; } else { x = x + " kinhdi = 'False',"; } if (ckbTra.Checked == true) { tl = tl + "tragedy, "; x = x + " tragedy = 'True',"; } else { x = x + " tragedy = 'False',"; } if (ckbBiAn.Checked == true) { tl = tl + "bi an, "; x = x + " bian = 'True',"; } else { x = x + " bian = 'False',"; } if (ckbTrinhT.Checked == true) { tl = tl + "trinh tham, "; x = x + " trinhtham = 'True',"; } else { x = x + " trinhtham = 'False',"; } if (ckbGGan.Checked == true) { tl = tl + "giat gan, "; x = x + " giatgan = 'True',"; } else { x = x + " giatgan = 'False',"; } if (ckbLM.Checked == true) { tl = tl + "lang man, "; x = x + " lanman = 'True',"; } else { x = x + " lanman = 'False',"; } if (ckbLN.Checked == true) { tl = tl + "lightnovel, "; x = x + " lightnovel = 'True',"; } else { x = x + " lightnovel = 'False',"; } if (ckbHT.Checked == true) { tl = tl + "hoc thuat, "; x = x + " sachht = 'True',"; } else { x = x + " sachht = 'False'"; } if (sach.UpdData(textBox5.Text, tl, textBox4.Text, textBox1.Text, textBox2.Text, txbAnh.Text, textBox7.Text, textBox8.Text, textBox6.Text, textBox9.Text, ids)) { if (sach.UpdDatatl(x, ids)) { MessageBox.Show("Sua thanh cong!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Vui long nhap day du cac muc co danh dau *!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }