public void Xoa(QLKTX.BusinessObject.DanTocInfo dt) { SqlCommand s = new SqlCommand("Delete DANTOC where MADANTOC=@ma"); s.Parameters.Add("@ma", SqlDbType.Int).Value = dt.MaDanToc; ser.Load(s); }
public void Sua(QLKTX.BusinessObject.DanTocInfo dt) { SqlCommand s = new SqlCommand("Update DANTOC set TENDANTOC = @ten where MADANTOC= @ma"); s.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = dt.TenDanToc; s.Parameters.Add("@ma", SqlDbType.Int).Value = dt.MaDanToc; ser.Load(s); }
public void Them(QLKTX.BusinessObject.DanTocInfo dt) { SqlCommand s = new SqlCommand("INSERT INTO DANTOC(MADANTOC,TENDANTOC) VALUES(@ma,@ten)"); s.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = dt.TenDanToc; s.Parameters.Add("@ma", SqlDbType.Int).Value = dt.MaDanToc; ser.Load(s); }
private void btnLuu_Click(object sender, EventArgs e) { if (txtTen.Text != "") { QLKTX.BusinessObject.DanTocInfo dt = new QLKTX.BusinessObject.DanTocInfo(); dt.MaDanToc = Convert.ToInt32(txtMa.Text); dt.TenDanToc = txtTen.Text.ToString(); ctl.Them(dt); DialogResult = DialogResult.Yes; } else { MessageBox.Show("Chưa nhập Tên!", "Dân Tộc", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void Sua(QLKTX.BusinessObject.DanTocInfo info) { data.Sua(info); }
public void Them(QLKTX.BusinessObject.DanTocInfo info) { data.Them(info); }