求助：PowerShell 5.0函数返回DataTable为何出现重复数据？

Let’s break down the most common causes of this frustrating issue, along with straightforward fixes for each scenario:

1. PowerShell’s Implicit Output Capturing (The #1 Culprit) #

PowerShell functions don’t only return what you specify with return — they capture all unassigned output streams from the function and bundle them into the final result.

For example, when you call $dt.Rows.Add(...), this method actually returns the newly added DataRow object. If you don’t suppress this output, those rows get added to the return value alongside your DataTable. When you assign the result to a variable, you end up with an array like [DataRow, DataRow, DataTable], which makes it look like your DataTable has duplicate data (especially if you iterate over the variable later).

Example of the Problem: #

function Get-UserTable {
    $dt = New-Object System.Data.DataTable
    $dt.Columns.Add("ID")
    $dt.Columns.Add("Username")

    # Rows.Add returns the new row, which gets implicitly added to output
    $dt.Rows.Add(1, "jdoe")
    $dt.Rows.Add(2, "asmith")

    return $dt
}

$output = Get-UserTable
# $output is an array: [DataRow, DataRow, DataTable]

Fix: #

Suppress the output from Rows.Add using one of these methods:

• Assign to $null: $null = $dt.Rows.Add(1, "jdoe")
• Cast to [void]: [void]$dt.Rows.Add(2, "asmith")
• Pipe to Out-Null: $dt.Rows.Add(3, "mjones") | Out-Null

2. Reusing a Persistent DataTable Instance #

If your DataTable is defined outside the function (e.g., as a global or script-level variable), every time you call the function, you’ll append data to the same table instead of creating a new one. This leads to cumulative data that looks like duplicates across calls.

Example of the Problem: #

# Defined outside the function — persists between calls
$global:sharedTable = New-Object System.Data.DataTable
$global:sharedTable.Columns.Add("ProductID")

function Get-ProductTable {
    $global:sharedTable.Rows.Add(101)
    return $global:sharedTable
}

$firstCall = Get-ProductTable # Has 1 row
$secondCall = Get-ProductTable # Has 2 rows (duplicate-looking data)

Fix: #

Create the DataTable inside the function to ensure a fresh instance every time:

function Get-ProductTable {
    $dt = New-Object System.Data.DataTable
    $dt.Columns.Add("ProductID")
    $dt.Rows.Add(101)
    return $dt
}

3. Accidental Extra Outputs in the Function #

Even small, overlooked outputs (like echoing a variable mid-function for debugging) can sneak into the return result. For example, if you print a row value without suppressing it, that value gets added to the output stream alongside your DataTable.

Example of the Problem: #

function Get-OrderTable {
    $dt = New-Object System.Data.DataTable
    $dt.Columns.Add("OrderID")

    $newRow = $dt.NewRow()
    $newRow["OrderID"] = 5001
    $dt.Rows.Add($newRow)

    # Accidental output — this gets added to the return result
    $newRow["OrderID"]

    return $dt
}

Fix: #

Audit your function for any unassigned outputs and suppress them. Use the same methods as in the first section ($null =, [void], Out-Null) to silence any unintended output.

How to Verify the Issue #

To confirm you’re dealing with extra output streams, check the type of your result variable:

$output = Get-MyDataTable
$output.GetType()

If the result is System.Object[] (an array) instead of System.Data.DataTable, you know there are extra objects being returned alongside your table.

内容的提问来源于stack exchange，提问作者codedawg82