Default SortDirection

[Luca Spolidoro]

When I click on a column to sort, the default SortDirection is Ascending.

I would like that the first time I click on any column, the default SortDirection is Descending.

Is it possible to achieve that?

[Srinivasan Vasu]

Hi Luca, 

 

Thanks for contacting Syncfusion support. 

 

We have checked your query and we have prepared a sample as per your requirement. You can achieve your requirement by using SfDataGrid.SortColumnsChanging and SfDataGrid.SortColumnsChanged event. 

 

Please refer the below code example. 

 

        this.datagrid.SortColumnsChanging += Datagrid_SortColumnsChanging; 

        this.datagrid.SortColumnsChanged += Datagrid_SortColumnsChanged; 

         

  private void Datagrid_SortColumnsChanged(object sender, GridSortColumnsChangedEventArgs e) 

        { 

            // Here, we have updated the column's items in view based on SortDescriptions. 

            if (e.Action == System.Collections.Specialized.NotifyCollectionChangedAction.Add) 

            { 

                var sortcolumn = this.datagrid.View.SortDescriptions.FirstOrDefault(x => x.PropertyName == e.AddedItems[0].ColumnName); 

                var sortDescription = new SortDescription(sortcolumn.PropertyName, ListSortDirection.Descending); 

                this.datagrid.View.SortDescriptions.Remove(sortcolumn); 

                this.datagrid.View.SortDescriptions.Add(sortDescription);              

            } 

        } 

        private void Datagrid_SortColumnsChanging(object sender, GridSortColumnsChangingEventArgs e) 

        { 

            // Initially, we can change the SortDirection of particular column based on columnchanged action. 

            if (e.Action == System.Collections.Specialized.NotifyCollectionChangedAction.Add) 

            { 

                e.AddedItems[0].SortDirection = ListSortDirection.Descending; 

            } 

        }              

 

 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/Samples_SortDirection1993456971.zip 

 

 

Regards, 

Srinivasan 

 

[Luca Spolidoro]

Hello Srinivasan,

this is a perfect solution! I think it should be added to the official guide: https://help.syncfusion.com/wpf/sfdatagrid/sorting

[Balamurugan Rajaraman]

Hi Luca, 

 

Thanks for the update. 

 

We will consider your suggestion and include this in to our documentation. 

 

Regards, 

Balamurugan R 

[John]

Is this still the recommended approach? I do think it would make a useful option. Anytime you're dealing with money or percentages/statistics you often want to sort by descending first. It's actually kinda rare to want ascending for numbers. Almost all my apps I do ascending for strings and descending for numeric.

[Vijayarasan Sivanandham]

Hi John,

Yes. This is the expected behavior when sorting the columns in SfDataGrid.

However, you can overcome this behavior by using the workaround suggested from our end.

Please let us know if you have any concerns in this.

Regards,

Vijayarasan S