July 10, 2012

DataTable DataView Sort


$dt = new-object System.Data.dataTable

$dt.Columns.Add("Name") | Out-Null
$dt.Columns.Add("size", [int]) | Out-Null


$row = $dt.NewRow()  
$row["Name"] = "Test"
$row["size"] = 10
$dt.Rows.Add($row)


$row = $dt.NewRow()  
$row["Name"] = "Test 2"
$row["size"] = 20
$dt.Rows.Add($row)


$dw = New-Object System.Data.DataView($dt)
$dw.Sort="size DESC"


$dw | Format-Table -AutoSize  # Or $dw | Out-GridView

$dt.Close
$dw.close



Output


Name   size
----   ----
Test 2   20
Test     10

1 comment: