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