private void btnSua_Click(object sender, EventArgs e) { Luat_DTO luat = new Luat_DTO(); luat.MaLuat = txtMaLuat.Text; luat.Luat = txtLuat.Text; xl.sua(luat); dataLuat.DataSource = xl.loadluat(); }
private void btnThem_Click(object sender, EventArgs e) { Luat_DTO luat = new Luat_DTO(); luat.MaLuat = txtMaLuat.Text; luat.Luat = txtLuat.Text; //luat.Nhom = txtNhom.Text; xl.them(luat); dataLuat.DataSource = xl.loadluat(); this.txtMaLuat.Text = ""; this.txtLuat.Text = ""; //MessageBox.Show("Thêm sự kiện thành công!"); }
public void sua(Luat_DTO sk) { String sql = "update tb_luat set LUAT=N'" + sk.Luat + "' where MALUAT='" + sk.MaLuat + "' "; kn.ThucHien(sql); }
public void them(Luat_DTO sk) { String sql = "insert into tb_luat values('" + sk.MaLuat + "',N'" + sk.Luat + "')"; kn.ThucHien(sql); }