Functions/Get-WITSqlrecordsetAsObj.ps1
|
<#
.Synopsis Short description .DESCRIPTION Long description .EXAMPLE Example of how to use this cmdlet .EXAMPLE Another example of how to use this cmdlet #> Function Get-WITSqlRecordsetAsObj { [CmdletBinding()] Param ( # Param1 help description [Parameter(Mandatory=$true, ValueFromPipelineByPropertyName=$true, Position=0)] $Recordset ) Begin { $allobj=@() } Process { while ($Recordset.eof -ne $true) { $obj=New-Object -TypeName pscustomobject for ($i = 0; $i -lt $Recordset.fields.count; $i++) { $field_name=$recordset.Fields($i).name $value=$recordset.Fields.Item($i).Value $obj| Add-Member $field_name $value } #end for $allobj+=$obj $recordset.movenext() } } End { return $allobj } } |