private void btnXoa_Click(object sender, EventArgs e) { try { DatabaseAccess.Update_HasOneParameter("DELETE_DM_Quan", "@TenQuan", cbbQuan2.Text); MessageBox.Show("Ðã xóa !"); DatabaseAccess.Select_HasNoParameter("SELECT_cbbQuan", cbbQuan2, "TenQuan"); } catch (System.Exception ex) { MessageBox.Show("Loi" + ex.ToString()); } }
private void cbbLuuQuan_Click(object sender, EventArgs e) { try { DatabaseAccess.Update_HasOneParameter("Insert_DM_Quan", "@TenQuan", txtQuan.Text); MessageBox.Show("Ðã thêm quận mới !"); //C?p nh?t l?i danh sách qu?n DatabaseAccess.Select_HasNoParameter("SELECT_cbbQuan", cbbQuan, "TenQuan"); } catch (System.Exception ex) { MessageBox.Show("Loi " + ex.ToString()); } }
private void itemXoa_Click(object sender, EventArgs e) { try { string selectedID = dgvDanhMucDat.SelectedRows[0].Cells["ID"].Value.ToString(); DatabaseAccess.Update_HasOneParameter("DELETE_DM_Dat", "@ID", selectedID); MessageBox.Show("Đã xóa !"); BindingSource bsDM_Dat = new BindingSource(); DatabaseAccess.Select_HasOneParameter("SELECT_frmDanhMucDat_dgr_Quan", bsDM_Dat, "@TenQuan", cbbQuan.Text); dgvDanhMucDat.DataSource = bsDM_Dat; DatabaseAccess.DanhSttDataGridView(dgvDanhMucDat); DatabaseAccess.ToMauChanLeDatagridView(dgvDanhMucDat); } catch (Exception ex) { MessageBox.Show(" Có lỗi xảy ra !" + ex.ToString()); } }