private void DeleteCampaign_Click(object sender, System.EventArgs e) { clsDBQueryManager obj_clsDBQueryManager = new clsDBQueryManager(); string campname = string.Empty; foreach (DataGridViewRow Dr in dgv_CampaignScraper.Rows) { try { if (Convert.ToBoolean(Dr.Cells[0].Value) == true) { campname = Dr.Cells[1].Value.ToString(); string query = "Delete from tb_CampaignScraper where CampaignName='" + campname + "';"; obj_clsDBQueryManager.DeleteCampaignScraperData(query); } } catch { } } DataSet DS = new DataSet(); DataTable DT = new DataTable(); try { DS = new clsDBQueryManager().getAllCampaignScraperData(); DT = DS.Tables[0]; dgv_CampaignScraper.DataSource = DT.DefaultView; } catch { } }