I've a pageable DataGrid bound to a DefaultView of a Table in a DataSet. Our client would like to see the last page first (which displays the most recent info), then go back to previous pages. For example, if there 5 pages, they will see "Page 5 of 5" first then they can click on the "Previous" link to see the other pages. How can I do that?

I've tried the following in the Page_Load event :

//Code Omitted
this.myDataGrid.DataSource = this.myDataSet.Tables[0].DefaultView;
this.myDataGrid.DataBind();
this.myDataGrid.CurrentPageIndex = this.myDataGrid.PageCount-1;
this.myDataGrid.DataSource = this.myDataSet.Tables[0].DefaultView;
this.myDataGrid.DataBind();
//Code Omitted

Which seems to display the last page but then Previous link doesn't work properly, it only pages back couple times and I never see the first page.