private void AddSach_Load(object sender, EventArgs e)
{
label10.Text = iD;
if (ids != "")
{
button2.Visible = false;
button3.Visible = false;
dt = sach.searchData(ids);
textBox5.Text = dt.Rows[0][1].ToString();
textBox4.Text = dt.Rows[0][3].ToString();
textBox1.Text = dt.Rows[0][4].ToString();
textBox2.Text = dt.Rows[0][5].ToString();
txbAnh.Text = dt.Rows[0][6].ToString();
textBox6.Text = dt.Rows[0][9].ToString();
textBox7.Text = dt.Rows[0][7].ToString();
textBox8.Text = dt.Rows[0][8].ToString();
textBox9.Text = dt.Rows[0][10].ToString();
dt = sach.searchDatatl(ids);
if (dt.Rows[0][1].ToString() == "'true'")
{
ckbHH.Checked = true;
}
;
if (dt.Rows[0][2].ToString() == "1")
{
ckbNL.Checked = true;
}
;
if (dt.Rows[0][3].ToString() == "1")
{
ckbPL.Checked = true;
}
;
if (dt.Rows[0][4].ToString() == "1")
{
ckbHH.Checked = true;
}
;
if (dt.Rows[0][5].ToString() == "1")
{
ckbDrama.Checked = true;
}
;
if (dt.Rows[0][6].ToString() == "1")
{
ckbFan.Checked = true;
}
;
if (dt.Rows[0][7].ToString() == "1")
{
ckbLS.Checked = true;
}
;
if (dt.Rows[0][8].ToString() == "1")
{
ckbCG.Checked = true;
}
;
if (dt.Rows[0][9].ToString() == "1")
{
ckbCT.Checked = true;
}
;
if (dt.Rows[0][10].ToString() == "1")
{
ckbKDi.Checked = true;
}
;
if (dt.Rows[0][11].ToString() == "1")
{
ckbTra.Checked = true;
}
;
if (dt.Rows[0][12].ToString() == "1")
{
ckbBiAn.Checked = true;
}
;
if (dt.Rows[0][13].ToString() == "1")
{
ckbTrinhT.Checked = true;
}
;
if (dt.Rows[0][14].ToString() == "1")
{
ckbGGan.Checked = true;
}
;
if (dt.Rows[0][15].ToString() == "1")
{
ckbLM.Checked = true;
}
;
if (dt.Rows[0][16].ToString() == "1")
{
ckbLN.Checked = true;
}
;
if (dt.Rows[0][18].ToString() == "1")
{
ckbHT.Checked = true;
}
;
}
else
{
button4.Visible = false;
button5.Visible = false;
}
}