We use the objectdatasource and the DataSourceForceStandardPaging in order to do our paging and sorting on the server. When a column is clicked on, the sortexpression sent to the object is incorrect. The sort expression is always one sort column behind. So if the you first click on col A, an empty sort expression is sent to the object. If you click on Col B, Col A is the sort expression. Click on Col C and Col B is the sort expression, etc.
Steps to Reproduce:
Open the attached web application. I have included an mdf file which should be useable if you have SQL express installed. If not, you will have to attach it in SQl Server and change the connection string.
Click on a column in the grid. Notice the sort expression printed at the top of the page is incorrect and the data is not sorted. Click a different column in the grid and notice the sort expression is the column you first clicked on. Notice the data is sorted by the last column you clicked on.
Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
I tested the fix and it works fine.
Thanks
Fix works.