Since Row_Number() is not available to SQL Server 2005 CE, are there any other alternatives for paging when querying the database?
Thanks.
In the next version of SQL CE, the TOP statement will be avaiable, and allow you to make your own paging solution, by combining TOP with a WHERE clause.|||So for the time being right now should I retrieve all data from the database and implement paging within the data access layer code? For example query and get 100 objects from the database but only return objects 30-40 to the application?|||You can use the ado bookmark
No comments:
Post a Comment