Switching ColumnSortDescriptor dynamically

[Jerry]

I have a Silverlight app with a telerik:RadGridView.

Depending on the query the users selects I want to sort a certain column. Only 1 column at a time.

In my code behind, I do the below. This works the first time, but when the other option is select and sort 2 is set, both columns are set to be sorted.

How do I only sort on one column at a time?

 

     ColumnSortDescriptor csd = new ColumnSortDescriptor();

     if (Mycheckbox.IsChecked == true)

{

csd.Column = MyGrid.Columns["Column1"];

csd.SortDirection = System.ComponentModel.ListSortDirection.Descending;

}

else

{

csd.Column = MyGrid.Columns["Column2"];
csd.SortDirection = System.ComponentModel.ListSortDirection.Descending;

}

MyGrid.SortDescriptors.Add(csd);

 

 

[Stefan Nenchev]

Hi Jerry,

When you initially create one of the SortDescriptors and you add it to the SortDescriptors collection of the RadGridView it stays in the collection unless you clear it. So in your case when you sort column1 and you then decide to sort column2, the SortDescriptors collection already contains the descriptor for the first column. In order to avoid such behavior you need to clear the SortDescriptors collection as in the code snippet below:

ColumnSortDescriptor csd = new ColumnSortDescriptor();
if (Mycheckbox.IsChecked == true)
{
 MyGrid.SortDescriptors.Clear();
 csd.Column = MyGrid.Columns["Column1"];
 csd.SortDirection = System.ComponentModel.ListSortDirection.Descending;
 MyGrid.SortDescriptors.Add(csd);
}
else
{
 MyGrid.SortDescriptors.Clear();
 csd.Column = MyGrid.Columns["Column2"];
 csd.SortDirection = System.ComponentModel.ListSortDirection.Descending;
 MyGrid.SortDescriptors.Add(csd);
}

Please, test this approach and update me if it works well for you.

Regards,
Stefan Nenchev
Telerik

[Jerry]

Yes, that works perfect!

Telerik may want to include that in the Sorting examples/documentation.

 

[Stefan Nenchev]

Hello Jerry,

I am glad to hear that the previously suggested implementation was useful at your end. Indeed, it is a good idea to include this approach in our documentation as it might be time-consuming for our customers to figure it out. We will consider adding it in the near future. I have added 500 points to your Telerik account as well.

Regards,
Stefan Nenchev
Telerik