Converts a DataRow object to a PSObject, Hashtable, or single value.
ConvertFrom-DataRow.ps1 [-DataRow] <DataRow> [-ProgressAction <ActionPreference>] [<CommonParameters>]
ConvertFrom-DataRow.ps1 [-DataRow] <DataRow> [-AsValues] [-ProgressAction <ActionPreference>]
[<CommonParameters>]
ConvertFrom-DataRow.ps1 [-DataRow] <DataRow> [-AsDictionary] [-ProgressAction <ActionPreference>]
[<CommonParameters>]
Invoke-Sqlcmd "select top 3 ProductID, Name from Production.Product" -ServerInstance ServerName -Database AdventureWorks |ConvertFrom-DataRow.ps1 |ConvertTo-Html
A record containing fields/columns to convert to an object with properties.
Type: DataRow
Parameter Sets: (All)
Aliases:
Required: True
Position: 1
Default value: None
Accept pipeline input: True (ByValue)
Accept wildcard characters: False
Indicates a the record’s values should be returned as an array.
Type: SwitchParameter
Parameter Sets: AsValues
Aliases: AsArray
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False
Indicates an ordered dictionary of fieldnames/columnnames to values should be returned rather than an object with properties.
Type: SwitchParameter
Parameter Sets: AsDictionary
Aliases: AsOrderedDictionary, AsHashtable
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False
Type: ActionPreference
Parameter Sets: (All)
Aliases: proga
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.