How to jump to the first page when a column is sorted

[Herman Gouw]

In my current project, I have a RadGrid with Paging and Sorting enabled.

The screenshot of the RadGrid is available on http://imageshack.us/f/848/dataaccessradgrid.jpg

When a column is sorted or unsorted, I would like the RadGrid to jump to the first page of the RadGrid.

Can you please show me how to do this?

Thanks,
Herman

[Vasil]

Hi Herman,

You can handle the SortCommand server-side event of the grid and change the current page index. Here is an example how to achieve this functionality:

Aspx:

<telerik:RadGrid ID="RadGrid1" runat="server" PageSize="5" AllowPaging="true" AllowSorting="true" OnNeedDataSource="RadGrid1_NeedDataSource" OnSortCommand="RadGrid1_SortCommand">
</telerik:RadGrid>

C#:

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
  (sender as RadGrid).DataSource = new int[] { 1, 2, 3, 4, 5, 6, 7, 8, 9 };
}
protected void RadGrid1_SortCommand(object sender, GridSortCommandEventArgs e)
{
  (sender as RadGrid).CurrentPageIndex = 0;
}

All the best,
Vasil
the Telerik team