public/Get-DataTableRow.ps1
|
<#PSScriptInfo
{ "VERSION": "1.0.0.0", "GUID": "6818cfc2-a6b6-47cd-bace-65ec64761930", "FILENAME": "Get-DataTableRow.ps1", "AUTHOR": "Hannes Palmquist", "AUTHOREMAIL": "hannes.palmquist@outlook.com", "CREATEDDATE": "2020-10-13", "COMPANYNAME": "Personal", "COPYRIGHT": "(c) 2020, Hannes Palmquist, All Rights Reserved" } PSScriptInfo#> function Get-DataTableRow { <# .DESCRIPTION Retreive rows from DataTable .PARAMETER DataTable Pass the data table object to get rows from .PARAMETER 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 .EXAMPLE Get-DataTableRow -DataTable $DataTable -Query '[OrderID] = 123456789' This example demonstrates how to retreive rows from data table. #> [CmdletBinding()] # Enabled advanced function support param( [System.Data.DataTable] $DataTable, [string] [Alias('SQLQuery')] $Query ) PROCESS { try { $DataTable.Select($Query) } catch { Throw $_ } } } #endregion |