CODEWITHSUNDEEP
c#wpfwpfdatagrid
Hussein Khalil
Hussein Khalil

Reputation: 1615

WPF Datagrid: Clear column sorting

I am using a WPF Datagrid in my application where columns can be sorted by clicking on the header.

I was wondering if there was any way to clear a column's sorting programatically ?

I tried sorting a column and then clearing MyDataGrid.Items.SortDescriptions, but that collection was empty (even though one column was sorted).

I also tried :

MyDataGridColumn.SortDirection = null;

The problem is that the column indication is gone, but the sorting still occurs when editing a cell and switching rows.

Is there no way to clear a column's sort ?

Edit (for clarity): The problem is that I'd like to allow sorting again if the user re-clicks on the same column header, so setting CanUserSort to false would be problematic, even if it were done in the XAML. In short, what I'm attempting to do, is prevent rows from being ordered once a sorted column has a cell that was modified. I want to force the user to re-click on the header.

Upvotes: 15

Views: 14195

Answers (7)

Chris
Chris

Reputation: 1139

as an extension...

    public static  void ClearSort(this DataGrid grid)
    {
        var view = CollectionViewSource.GetDefaultView(grid.ItemsSource);
        view?.SortDescriptions.Clear();

        foreach (var column in grid.Columns)
        {
            column.SortDirection = null;
        }
    }

Upvotes: 6

iato
iato

Reputation: 424

This is what I use in my program (I have a RESET button and use this to clear the sorting on a datagrid).

System.Windows.Data.CollectionViewSource.GetDefaultView(MY_DATA_GRID.ItemsSource).SortDescriptions.Clear();

Works like a charm.

Cheers, Iato

Upvotes: 1

NoOne
NoOne

Reputation: 4091

Here is what you need:

using System.Windows.Data;
using System.ComponentModel;

ICollectionView view = CollectionViewSource.GetDefaultView(grid.ItemsSource);
if (view != null)
{
    view.SortDescriptions.Clear();
    foreach (DataGridColumn column in grid.Columns)
    {
        column.SortDirection = null;
    }
}

Original source: https://stackoverflow.com/a/9533076/964053

What I want to know is what was M$ thinking for not putting a ClearSort() method...

Upvotes: 21

Jassim
Jassim

Reputation: 17

In XAML you can turn it off using this code.

<DataGridTextColumn Header="Header Name" CanUserSort="False"/>

Upvotes: 0

Vaibhav
Vaibhav

Reputation: 15

This is a small code snippet to disable the sorting of DataGridView.

for (int i = 0; i < dataGridView1.ColumnCount; i++)
{
    dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
}

Upvotes: -2

Vaibhav
Vaibhav

Reputation: 15

In the XAML code of DataGrid you can add CanUserSortColumns="False". Then noboady would be able to sort any column at rumtime.

Upvotes: -2

Rohit Vats
Rohit Vats

Reputation: 81253

Set CanUserSort to false for all columns -

foreach (var a in MyDataGrid.Columns)
{
    a.CanUserSort = false;
}

Upvotes: 4

Related Questions