Avoid auto sorting in RadGridView

[Sandipa]

I want to sort the grid only on Header click. In sorting when ever we modify the value of the sorted column the rows get auomatically sorted based on the value.
I just want to avoid this auto sorting during modifying the cell values, it should happen only on header click. Is this possible in RadGridView for win form ?

[Dimitar]

Hello Sandipa,

Thank you for writing.

Even if you remove the sort descriptors when a value is changed the original row appearance will occur. And the original data source row order will be restored. In general if you have a sort descriptor (when the user clicks the header cell such is created) the columns will be sorted by its criteria or if there is no sort descriptor the rows order will match the one from the data source. 

If you have any questions, please do not hesitate to contact us.

Regards,
Dimitar
Telerik

[Göran]

Hi, is it possible to achieve the "sort only on header click" behavior. 
So the list is only sorted once when the user clicks on the header, new rows will be appended at the bottom and updated rows will not be auto sorted.
Regards

[Dimitar]

Hi Goran,

Thank you for writing.

As mentioned in my previous post this is not supported in RadGridView, as in fact this is no longer sorting. Nevertheless you can disable the built-in sorting an handle the header cell click yourself. For example you can sort the underlying data source which will give you the desired functionality:

BindingList<MyTestClass> list = new BindingList<MyTestClass>();
void radGridView1_MouseClick(object sender, MouseEventArgs e)
{
    var element = radGridView1.GridViewElement.ElementTree.GetElementAtPoint(e.Location) as GridHeaderCellElement;
    if (element != null)
    {
        List<MyTestClass> sorted = list.OrderByDescending(x => x.value).ToList();

        BindingList<MyTestClass> source = new BindingList<MyTestClass>(sorted);
        radGridView1.DataSource = source;
    }
}

I hope this helps.

Regards,
Dimitar
Telerik