private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex == -1) { return; } if (e.ColumnIndex == 1) { int scheduleId = 0; if (int.TryParse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(), out scheduleId)) { if (scheduleId != -1) { DialogResult result = MessageBox.Show("Are you sure you want to delete this Job?", "Delete Schedule-Job", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { //delete from userinfo, schedule_save_location and logs first //userinfo firedumpdbDataSetTableAdapters.userinfoTableAdapter userAdapter = new firedumpdbDataSetTableAdapters.userinfoTableAdapter(); userAdapter.DeleteQueryByScheduleid(scheduleId); //logs firedumpdbDataSetTableAdapters.logsTableAdapter logAdapter = new firedumpdbDataSetTableAdapters.logsTableAdapter(); logAdapter.DeleteQueryByScheduleid(scheduleId); //save_locations firedumpdbDataSetTableAdapters.schedule_save_locationsTableAdapter saveLocAdapter = new firedumpdbDataSetTableAdapters.schedule_save_locationsTableAdapter(); saveLocAdapter.DeleteQueryByScheduleId(scheduleId); //last delete from schedule schedulesTableAdapter.DeleteQueryById(scheduleId); firedumpdbDataSet.schedulesDataTable scheduleTable = new firedumpdbDataSet.schedulesDataTable(); schedulesTableAdapter.FillOrderByDate(scheduleTable); dataGridView1.DataSource = scheduleTable; } } } } else { int scheduleId = 0; if (int.TryParse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(), out scheduleId)) { if (scheduleId != -1) { firedumpdbDataSetTableAdapters.schedule_save_locationsTableAdapter savelocAdapter = new firedumpdbDataSetTableAdapters.schedule_save_locationsTableAdapter(); firedumpdbDataSetTableAdapters.backup_locationsTableAdapter backAdapter = new firedumpdbDataSetTableAdapters.backup_locationsTableAdapter(); firedumpdbDataSet.schedule_save_locationsDataTable saveloctable = new firedumpdbDataSet.schedule_save_locationsDataTable(); savelocAdapter.FillByScheduleId(saveloctable, scheduleId); firedumpdbDataSet.backup_locationsDataTable backuptable = new firedumpdbDataSet.backup_locationsDataTable(); if (saveloctable.Count > 0) { backuptable = backAdapter.GetDataByID(saveloctable[0].backup_location_id); dataGridViewlocs.DataSource = backuptable; } //MessageBox.Show(scheduleId+" "+saveloctable.Count.ToString()); } } } }