View Single Post
  #2 (permalink)  
Old July 26th, 2008, 01:25 AM
Lee Dumond's Avatar
Lee Dumond Lee Dumond is offline
Wrox Author
Points: 4,942, Level: 29
Points: 4,942, Level: 29 Points: 4,942, Level: 29 Points: 4,942, Level: 29
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2008
Location: Decatur, IL, USA.
Posts: 923
Thanks: 12
Thanked 166 Times in 162 Posts
Default

Server-side paging can be tricky when using T-SQL, because ObjectDataSource does paging differently that SQL Server. You must remember to take this into account.

Examine the GetPageIndex method in BizObject and you'll see what I mean. ObjectDataSource works with row indexes, while SQL works with page indexes. You can calculate the starting page index from the starting row index using this GetPageIndex method.