Skip to main content

Get-DataTableRow

SYNOPSIS#

SYNTAX#

Get-DataTableRow [[-DataTable] <DataTable>] [[-Query] <String>] [<CommonParameters>]

DESCRIPTION#

Retreive rows from DataTable

EXAMPLES#

EXAMPLE 1#

Get-DataTableRow -DataTable $DataTable -Query '[OrderID] = 123456789'

This example demonstrates how to retreive rows from data table.

PARAMETERS#

-DataTable#

Pass the data table object to get rows from

Type: DataTable
Parameter Sets: (All)
Aliases:
Required: False
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Query#

Define a query.

-like : like -gt : > -lt : \< -eq : =

Values should be enclosed with single qoutation marks Columns should not be enclosed with quotation marks

Type: String
Parameter Sets: (All)
Aliases: SQLQuery
Required: False
Position: 2
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters#

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS#

OUTPUTS#

NOTES#

RELATED LINKS#

EDIT THIS DOC#

This page was auto-generated from the powershell command comment based help. To edit the content of this page, update the script file comment based help on github Github