如何删除选中行datagridview中的记录，并在删除后更新数据库？

// 获取选中行的数据
List<int> selectedRows = new List<int>();
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
    selectedRows.Add(row.Index);
}

// 删除选中行
foreach (int rowIndex in selectedRows)
{
    dataGridView1.Rows.RemoveAt(rowIndex);
}

// 更新数据库
using (SqlConnection connection = new SqlConnection("数据库连接字符串"))
{
    connection.Open();
    foreach (int rowIndex in selectedRows)
    {
        // 获取要删除的记录的唯一标识符（如ID）
        int recordId = Convert.ToInt32(dataGridView1.Rows[rowIndex].Cells["ID"].Value);

        // 执行删除操作
        string deleteQuery = "DELETE FROM 表名 WHERE ID = @RecordId";
        using (SqlCommand command = new SqlCommand(deleteQuery, connection))
        {
            command.Parameters.AddWithValue("@RecordId", recordId);
            command.ExecuteNonQuery();
        }
    }
}