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 !");
}
