Powershell set default sorting on datagrid

Question

So i have this wpf datagrid whose columns are defined in a xaml file, i programmatically check data and insert rows in it 1 by 1 after a button is pressed.

I'm trying to understand how i can populate it and set a sorting (the same sorting as i would have clicking on a column header)

in winforms i used to add:

$myDataGrid.Sort($myDataGrid.Columns[3],'Ascending')

after my populating function.

How do i replicate that in WFP (and powershell)?

i did try:

$Datagrid.Items.SortDescription.Add([pscustomobject]@{ColumnName="MyColumn";SortDirection="ListSortDirection.Ascending"})

but i'm having quite some trouble as i only find c# explanations and trying to adapt is not working out....

It's PropertyName and Direction, not ColumnName and SortDirection: $Datagrid.Items.SortDescription.Add([System.ComponentModel.SortDescription]@{PropertyName="MyColumn"; Direction="Ascending"}) — Mathias R. Jessen
– Mathias R. Jessen, Commented Mar 2, 2022 at 14:25
Throws an error: Exception during call of "Add" with 1 argument: the collection has fixed size — Wyatt_LandWalker
– Wyatt_LandWalker, Commented Mar 2, 2022 at 14:28
There's an s missing (it's SortDescriptions, not SortDescription) — Mathias R. Jessen
– Mathias R. Jessen, Commented Mar 2, 2022 at 14:32
It works! damn typos. Where would you find the names anyway? i am having issues scraping microsoft documentation — Wyatt_LandWalker
– Wyatt_LandWalker, Commented Mar 2, 2022 at 14:36

mm8 · Accepted Answer · 2022-03-02 14:31:59Z

2

Try this:

$sortDescription = New-Object System.ComponentModel.SortDescription('MyColumn', 'Ascending')
$Datagrid.Items.SortDescriptions.Add($sortDescription)

answered Mar 2, 2022 at 14:31

mm8

170k10 gold badges70 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Wyatt_LandWalker Over a year ago

Thank you! i like Mathias answer cause it's a one liner but you actually cleared a doubt i had about how to handle objects and creating them.

Ricky · Accepted Answer · 2022-04-07 12:32:54Z

0

In C# the solution is this, I hope this can help you to understand how WPF works.

To sort your DataGrid like if you clicked on your column 3, you have to work on DataView created from WPF. In this exampe the DataGrid is sorted every time that columns are AutoGenerated but you can select other event like DataGrid1_Loaded

using System.Windows.Data;

private void DataGrid1_AutoGeneratedColumns(object sender, EventArgs e)
    {
        (((DataGrid)sender).ItemsSource as DataView).Sort = DataGrid1.Columns[3].Header.ToString();
    }

edited Apr 7, 2022 at 12:32

answered Apr 6, 2022 at 15:57

Ricky

1037 bronze badges

Collectives™ on Stack Overflow

Powershell set default sorting on datagrid

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related