[Solved] Multi Column sorting in radgrid

[Balajee Vasudevan]

Hi, 
 
I want to implement the multicolumn sorting for radgrid placed in the user control .i have some default sorting (multi column) depends on the page where the user control is used . so , i have used the following code to set the default sorting in the user control ,

<

 

SortExpressions>

 

 

<telerik:GridSortExpression FieldName="SupplierDueDate" SortOrder="Ascending" />

 

 

<telerik:GridSortExpression FieldName="CountyName" SortOrder="Ascending" />

 

 

<telerik:GridSortExpression FieldName="Municipality" SortOrder="Ascending" />

 

 

<telerik:GridSortExpression FieldName="PostalCode" SortOrder="Ascending" />

 

 

<telerik:GridSortExpression FieldName="CooperativeHousing" SortOrder="Ascending" />

 

</

 

SortExpressions>

Then i planned to change these settings(i.e) the columns  programmatically in the server side (to overrride these settings based on the page) like these:

 

 

case "MyOrders":

 

 

 

 

 

 

 

 

 

this.grdOrderList.MasterTableView.SortExpressions.Clear();

 

sortExpr =

new GridSortExpression();

 

sortExpr.FieldName =

"CreatedTime";

 

sortExpr.SortOrder =

GridSortOrder.Ascending;

 

 

this.grdOrderList.MasterTableView.SortExpressions.AddSortExpression(sortExpr);

 

 

break;

 

 

But this seems not working ... since using the sortExpression.Clear() i see a small command button in the headers of the column(just beside the column name ) .... please tell  me where im going wrong with the possible solution to implement the above 

thanks in advance,
Balajee


 

[Johny]

Hello Balajee,

Have you tried rebinding the grid after setting the sort expression in the code-behind? In this documentation link such approach is used:

http://www.telerik.com/help/aspnet-ajax/grdsortingexpressions.html

I hope this helps.
Johny

[Balajee Vasudevan]

Hi Johny,

yes, that played the trick.. now the code works absolutely fine...

Also, can you tell me how do i perform multiple column sorting programattically 
for example

if i want to set multicolumn sorting like this 

this

 

.grdOrderList.MasterTableView.SortExpressions.Clear();

 

sortExpr =

new GridSortExpression();

 

sortExpr.FieldName =

"CreatedTime";

 

sortExpr.FieldName =

"EmpName";

 

sortExpr.SortOrder =

GridSortOrder.Ascending;

 

 

this.grdOrderList.MasterTableView.SortExpressions.AddSortExpression(sortExpr);

 

 

this.grdOrderList.MasterTableView.Rebind();

The collection doesnt seem to hold both the values ...but only the latest "EmpName" ....

thanks in advance,
Balajee

 

[Johny]

Hi Balajee,

You will need to create a new sortExpression object for every field that you want sorted. So you can try the following modification:

this.grdOrderList.MasterTableView.SortExpressions.Clear();
        sortExpr = new GridSortExpression();
        sortExpr.FieldName = "CreatedTime";
        sortExpr.SortOrder = GridSortOrder.Ascending;
        this.grdOrderList.MasterTableView.SortExpressions.AddSortExpression(sortExpr);

        sortExpr = new GridSortExpression();
        sortExpr.FieldName = "EmpName";
        sortExpr.SortOrder = GridSortOrder.Ascending;
        this.grdOrderList.MasterTableView.SortExpressions.AddSortExpression(sortExpr);

        this.grdOrderList.MasterTableView.Rebind();

Thanks
Johny

[Balajee Vasudevan]

Hi,

Thanks for the solution . this works fine .


Thanks,
Balajee