Datagrid Multiple Column Sorting

Question

My datagrid is setup like this:

ItemsSource bound to ObservableCollection
Handling Sorting event
- e.Handled = true;
- Clear observable collection
- Query database with sorting logic
- Foreach result add to observable collection

This works great but I want to enable multiple column sorting. It's my understanding that holding shift while clicking column headings is the way the end user does this. But in the sorting event, I don't know how to get a hold of the sort descriptions.

Here's my code for single column server side sorting, which works fine:

public class DataGrid : System.Windows.Controls.DataGrid
{
    public event EventHandler<SortExpressionConstructedEventArgs> SortExpressionConstructed;

    public void OnSortExpressionConstructed(SortExpressionConstructedEventArgs e)
    {
        EventHandler<SortExpressionConstructedEventArgs> handler = SortExpressionConstructed;
        if (handler != null) handler(this, e);
    }


    public DataGrid()
    {
        Sorting += DataGridSorting;
    }

    void DataGridSorting(object sender, System.Windows.Controls.DataGridSortingEventArgs e)
    {
        e.Handled = true;
        e.Column.SortDirection = e.Column.SortDirection != ListSortDirection.Ascending
                                     ? ListSortDirection.Ascending
                                     : ListSortDirection.Descending;

        var sd = new SortDescription(e.Column.SortMemberPath, e.Column.SortDirection.Value);
        OnSortExpressionConstructed(new SortExpressionConstructedEventArgs(sd));
    }
}

public class SortExpressionConstructedEventArgs : EventArgs
{
    public SortExpressionConstructedEventArgs(SortDescription sortDescription)
    {
        SortDescription = sortDescription;
    }

    public SortDescription SortDescription { get; private set; }

    // event handler can use this to sort the query
    public IOrderedQueryable<T> Order<T>(IQueryable<T> queryable)
    {
        switch (SortDescription.Direction)
        {
            case ListSortDirection.Ascending:
                return enumerable.OrderBy(SortDescription.PropertyName);

            case ListSortDirection.Descending:
                return enumerable.OrderByDescending(SortDescription.PropertyName);

            default:
                throw new ArgumentOutOfRangeException();
        }
    }
}

Ronnie Overby · Accepted Answer · 2012-08-30 19:56:53Z

1

My solution was to manually track the sorted columns in the derived DataGrid class, which is working well.

https://github.com/ronnieoverby/RonnieOverbyGrabBag/blob/master/DataGrid.cs

answered Aug 30, 2012 at 19:56

Ronnie Overby

46.7k75 gold badges273 silver badges350 bronze badges

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

Comments

Peter Csala · Accepted Answer · 2020-11-16 10:12:00Z

0

My method is work for me. Just try this code.

if (dgEvents.ItemsSource == null)
    dgEvents.ItemsSource = events.Entries;

CollectionViewSource.GetDefaultView(dgEvents.ItemsSource).Refresh();

dgEvents.Items.SortDescriptions.Clear();

dgEvents.Items.SortDescriptions.Add(new SortDescription(dgEvents.Columns[0].SortMemberPath, ListSortDirection.Descending));


foreach (var col in dgEvents.Columns)
{
    col.SortDirection = null;
}

dgEvents.Columns[0].SortDirection = ListSortDirection.Descending;

dgEvents.Items.Refresh();

edited Nov 16, 2020 at 10:12

Peter Csala

23.7k16 gold badges51 silver badges96 bronze badges

answered Nov 3, 2016 at 6:38

vajarkov

415 bronze badges

Collectives™ on Stack Overflow

Datagrid Multiple Column Sorting

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related