This question is locked. New answers and comments are not allowed.
Using 2008.03 controls w/ new ORM in VS 2008 Arc Ed.
SQL 2005 Express for DB
Table Customer
--ID int identity(1,1)
--Name nvarchar(50)
I built a simple little app to test the binding w/ the grid and noticed that it doesn't page quite right. I created a customer object (id,name) for testing populated it with 150 records to page. The binding and sorting all went well and then I paged from 1 to 2 with no problem. However from pages 3 and > it continued to show the records of page 2, even though the pager displayed the page I expected to be on. when I started scrolling back it stayed showing page 2's results for all pages - until I got back to page 1 which displayed properly.
I changed the paging style to numeric instead and got the same result. Page 1 displays properly and all other pages show what should be page 2. It doesn't matter what sort is set, it always does the same thing.
When I view the profiler, I got very happy that no Select * stuff was happening but instead good SQL to only return the proper 10 records which is fantastic - now if you can just sent the right parameter values it'll be perfect! ;-)
[Edit]
Just for clarification the RadGrid is bound to an OpenAccessDataSource.
[/Edit]
Al
SQL 2005 Express for DB
Table Customer
--ID int identity(1,1)
--Name nvarchar(50)
I built a simple little app to test the binding w/ the grid and noticed that it doesn't page quite right. I created a customer object (id,name) for testing populated it with 150 records to page. The binding and sorting all went well and then I paged from 1 to 2 with no problem. However from pages 3 and > it continued to show the records of page 2, even though the pager displayed the page I expected to be on. when I started scrolling back it stayed showing page 2's results for all pages - until I got back to page 1 which displayed properly.
I changed the paging style to numeric instead and got the same result. Page 1 displays properly and all other pages show what should be page 2. It doesn't matter what sort is set, it always does the same thing.
When I view the profiler, I got very happy that no Select * stuff was happening but instead good SQL to only return the proper 10 records which is fantastic - now if you can just sent the right parameter values it'll be perfect! ;-)
[Edit]
Just for clarification the RadGrid is bound to an OpenAccessDataSource.
[/Edit]
Al