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(); } }