Server-side paging with DevExpress without XPO

Question

Is there any (relatively) easy way to implement server-side paging using DevExpress controls (either Win- or Web-ones) without using an XPO data source? By server-side paging I mean control retrieving only the records it needs to display from the database, not the whole table.

Answer 1

If your data source is LINQ-capable, recent DevExpress versions should be able to do the right thing.

Otherwise, you need to implement IListServer. I'm struggling with the same thing right now, so this is not exactly an "answer". I have not found a working example, but there's some useful information in their knowledge base here: http://www.devexpress.com/Support/Center/KB/p/A1022.aspx

Answer 2

If you don't want to use LINQ you could try this example for an ObjectDataSource: http://www.devexpress.com/Support/Center/e/E166.aspx