tag:blogger.com,1999:blog-6957535040891691485.post8876038133322005176..comments2023-07-29T00:27:40.642-07:00Comments on STADIUM: Enabling server side paging on gridsAnonymoushttp://www.blogger.com/profile/15628476634920958723noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6957535040891691485.post-3541079218004726712011-12-05T06:48:15.000-08:002011-12-05T06:48:15.000-08:00should put SELECT ROW_NUMBER() OVER (ORDER BY {%Pa...should put <br>SELECT ROW_NUMBER() OVER (ORDER BY {%PagingDefaultSortColumn%}) AS EmployeeRowNumber<br><br>after your normal selection<br><br>Like:<br><br>SELECT *, ROW_NUMBER() OVER (ORDER BY {%PagingDefaultSortColumn%}) AS EmployeeRowNumber<br> FROM Employees where {%FilterSearchCondition%}<br><br><br>And also be aware of {%PagingDefaultSortColumn%} is case sensitiveNancy Van Den Berghttp://www.facebook.com/huangyunduannoreply@blogger.comtag:blogger.com,1999:blog-6957535040891691485.post-82793992867197175382011-08-23T05:45:21.000-07:002011-08-23T05:45:21.000-07:00Does server side paging on the datagrid affect the...Does server side paging on the datagrid affect the export to excel functionality?Raynardt Schulze-Messingnoreply@blogger.comtag:blogger.com,1999:blog-6957535040891691485.post-90512398234967143922011-08-23T05:47:38.000-07:002011-08-23T05:47:38.000-07:00Export to excel should work fine with server side ...Export to excel should work fine with server side paging.annu augustinehttp://stadium3.wordpress.comnoreply@blogger.com