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

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