Geek Answers Handbook

Server Paging with DevExpress without XPO

Is there a (relatively) easy way to implement server paging using DevExpress controls (either Win- or Web-) without using an XPO data source? By server paging, I mean management that receives only the records that it needs to display from the database, and not the entire table.

+3
source share
3 answers

You must create custom paging control (do not use DevEx paging). Send the current page and page size to the procedure as a parameter or use directly in your request.

How to use this example value in MS SQL, this link: http://msdn.microsoft.com/en-us/library/ms186734.aspx

In Oracle and other databases, you can do this using different technologies. Regards.

+1
source

If your data source supports LINQ, the latest versions of DevExpress should be able to do the right thing.

Otherwise, you need to implement IListServer. I am struggling with the same thing now, so this is not exactly the “answer”. I did not find a working example, but there is useful information in their knowledge base: http://www.devexpress.com/Support/Center/KB/p/A1022.aspx

0
source

If you do not want to use LINQ, you can try this example for an ObjectDataSource object: http://www.devexpress.com/Support/Center/e/E166.aspx

0
source

More articles:


All Articles