synchronise sorting with second grid

[Christian]

In my application I have to synchronise sorting from the first grid with the second grid.

Both grid get the same data from the same datatable.

Now I need programm that if the user sorts one column in the first grid, the same column should be sorted in the second grid automaticly.

What is the way to go?

Christian

[Shinu]

Hi Christian,

You can use the same SortCommand event for both the Grid and try the following code snippet in the SortCommand event to achieve the desired scenario.


ASPX:

 <telerik:RadGrid ID="RadGrid1" AllowSorting="true" OnNeedDataSource="RadGrid1_NeedDataSource" OnSortCommand="RadGrid1_SortCommand">
 .........

 <telerik:RadGrid ID="RadGrid2"  runat="server" OnNeedDataSource="RadGrid2_NeedDataSource" AllowSorting="True" OnSortCommand="RadGrid1_SortCommand">

CS:

  protected void RadGrid1_SortCommand(object source, GridSortCommandEventArgs e)
    {
        RadGrid Grid = (RadGrid)source;

        GridSortExpression sortExp = new GridSortExpression();
        sortExp.FieldName = e.SortExpression;
        sortExp.SortOrder=e.NewSortOrder;
        if (Grid.ID == "RadGrid1")
        {
            RadGrid2.MasterTableView.SortExpressions.AddSortExpression(sortExp);
            RadGrid2.MasterTableView.Rebind();
        }
        else if (Grid.ID == "RadGrid2")
        {
            RadGrid1.MasterTableView.SortExpressions.AddSortExpression(sortExp);
            RadGrid1.MasterTableView.Rebind();
        }
    }

Thanks
Shinu

[Christian]

Hi Shinu,

thank you!

Please tell your boss that I'm very lucky with your support!

Christian