private void button2_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow dr_dgv in dgv_kmKhachHang.SelectedRows)
{
DataRow dr = ((DataRowView)dr_dgv.DataBoundItem).Row;
provider p = new provider();
p.Connect();
string sql = "Delete KHACHHANG where MaKhachHang='" + dr[0].ToString() + "'";
p.ExcuteNonQuery(sql, CommandType.Text);
dt1.Rows.Remove(dr);
p.Disconnect();
////try
////{
//// foreach(DataGridViewRow dgv_row in dgv_kmKhachHang.SelectedRows){
//// DataRow dr = ((DataRowView)dgv_row.DataBoundItem).Row;
//// string sql = "delete MUCUUDAIKHACHHANG where LoaiUuDai = '" + dr[1].ToString();
//// SqlConnection conn = new SqlConnection(@"Data Source=.;Initial Catalog=QuanLySieuThi;Integrated Security=True");
//// conn.Open();
//// SqlCommand cmd = new SqlCommand(sql, conn);
//// cmd.CommandType = CommandType.Text;
//// cmd.ExecuteNonQuery();
//// }
}
}
private void button2_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow dr_dgv in dgv_qlNhanVien.SelectedRows)
{
DataRow dr = ((DataRowView)dr_dgv.DataBoundItem).Row;
provider p = new provider();
string sql = "Delete NHANVIEN where MaNhanVien='" + dr[0].ToString() + "'";
p.ExcuteNonQuery(sql, CommandType.Text);
dt1.Rows.Remove(dr);
}
}
private void button4_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow dr_dgv in dgv_ctHoaDon.SelectedRows)
{
DataRow dr = ((DataRowView)dr_dgv.DataBoundItem).Row;
provider p = new provider();
p.Connect();
string sql = "Delete CHITIETHOADON where MaHoaDon='" + dr[0].ToString() + "'";
p.ExcuteNonQuery(sql, CommandType.Text);
dt1.Rows.Remove(dr);
p.Disconnect();
}
}
private void btn_sua_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow dr_dgv in dgv_kmKhachHang.SelectedRows)
{
DataRow dr = ((DataRowView)dr_dgv.DataBoundItem).Row;
dr[0] = txb_maKhachHang.Text;
dr[1] = txb_tenKhachHang.Text;
dr[2] = txb_soDienThoai.Text;
dr[3] = txb_diaChi.Text;
dr[4] = txb_diemTichLuy.Text;
provider p = new provider();
p.Connect();
string sql = "update KHACHHANG set MaKhachHang='" + txb_maKhachHang.Text + "',TenKhachHang ='" + txb_tenKhachHang.Text + "',SoDienThoai=" + txb_soDienThoai.Text + ",DiaChi='" + txb_diaChi.Text + "',DiemTichLuy=" + txb_diemTichLuy.Text + "where MaKhachHang='" + dgv_kmKhachHang.Rows[dgv_kmKhachHang.CurrentCell.RowIndex].Cells[0].Value.ToString() + "'";
//"where MaKhachHang='" + txb_maKhachHang.Text+ "'";
p.ExcuteNonQuery(sql, CommandType.Text);
p.Disconnect();
}
}
