// delete rows private void button_Delete_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { return; } // collect ids to delete string flightNos = "("; for (int i = 0; i < dataGridView1.SelectedRows.Count; i++) { flightNos += "'" + dataGridView1.SelectedRows[i].Cells[0].Value.ToString() + "'"; if (i != dataGridView1.SelectedRows.Count - 1) { flightNos += ","; } } flightNos += ")"; if (MessageBox.Show("Sure to delete flights whose no. in " + flightNos + "?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No) { return; } // call the model's delete method Model.Flight flight = new Model.Flight(); if (flight.Delete(flightNos)) { Log.Add(Program.user.ID, "Delete flight " + flightNos + "."); // delete from datagridview foreach (DataGridViewRow dataGridView1Row in dataGridView1.SelectedRows) { dataGridView1.Rows.Remove(dataGridView1Row); } } }