Beispiel #1
0
        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();
        }
Beispiel #2
0
        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);
        }