private void btnXoa_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(@" Data Source=DESKTOP-H1LP27V;Initial Catalog=QuanLyKhoHang;Integrated Security=True"); accessData acc = new accessData(); string sql = "delete from SanPham where MaSP='" + tbxMaSP.Text + "'"; acc.excuteNonQuery(sql); try { tbxMaSP.Clear(); tbxTenSP.Clear(); tbxMaLSP.Clear(); tbxMaHSX.Clear(); tbxGiaBan.Clear(); tbxBaoHanh.Clear(); tbxTinhNang.Clear(); } catch { } MessageBox.Show("Xoá thành công !"); SanPham_Load(sender, e); }
private void btnXoa_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(@" Data Source=DESKTOP-H1LP27V;Initial Catalog=QuanLyKhoHang;Integrated Security=True"); accessData acc = new accessData(); string sql = "delete from NhanVien where MaSP='" + tbxMaNV.Text + "'"; acc.excuteNonQuery(sql); try { tbxMaNV.Clear(); tbxHoTen.Clear(); //tbxNgaySinh.Clear(); //tbxGioiTinh.Clear(); tbxDiaChi.Clear(); tbxSoDienThoai.Clear(); } catch { } MessageBox.Show("Xoá thành công !"); try { tbxMaNV.Clear(); tbxHoTen.Clear(); // dtNgaySinh.Clear(); // cbxGioiTinh.Clear(); tbxDiaChi.Clear(); tbxSoDienThoai.Clear(); } catch { } MessageBox.Show("Xoá thành công !"); }
private void btnXoa_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(@" Data Source=DESKTOP-H1LP27V;Initial Catalog=QuanLyKhoHang;Integrated Security=True"); accessData acc = new accessData(); string sql = "delete from PhieuNhap where MaPN='" + tbxMaPN.Text + "'"; acc.excuteNonQuery(sql); try { tbxMaPN.Clear(); tbxMaSP.Clear(); tbxMaHSX.Clear(); tbxMaNV.Clear(); tbxNgayNhap.Clear(); tbxSoLuong.Clear(); tbxDonGia.Clear(); } catch { } MessageBox.Show("Xoá thành công !"); }