循环通过Data GridView并获取所有选定行的ID，然后在C#中从数据库中删除

List<int> selectedIds = new List<int>();
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
    int id = Convert.ToInt32(row.Cells["ID"].Value);
    selectedIds.Add(id);
}

string connectionString = "YourConnectionString"; // 替换为你的数据库连接字符串
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    foreach (int id in selectedIds)
    {
        string query = $"DELETE FROM YourTable WHERE ID = {id}"; // 替换为你的表名和ID列名
        SqlCommand command = new SqlCommand(query, connection);
        command.ExecuteNonQuery();
    }
}

dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
// 重新加载数据到DataGridView