Can I have a general idea of server-side paging? What are the steps? I am working on Silverlight DataGrid and the requirement is to use server-side paging. I did google but stumbled, reason being too much advance information in almost every article for a newbie like me. Also most of them used WCF RIA services which I have no idea. I just need to know how actually you do server side paging and if someone could guide in the Silverlight scenario that would be great.
The Idea is to send the no of records/page,order by/sorting,page no as parameter to the stored procedure and bind the results of PagedCollection to the DataGrid Source.
Server side, means that something works on server or it works at computer where IIS is installed. Client side means that something works in browser. If to speak about architecture XAML, and it's .cs code and anything related to silverlight part are compiled into .XAP file and executed in browser, by silverlight plugin - so it's client-side. So server side paging means that you need to make some C# code on the server, which will return you only requested page. For example you have 160 records, and at single page you want to show 10 records. Without server side paging each time you give to client ( or something that works in browser ) 160 records, and silverlight will filter from it 10 records. But with server side paging you'll return only 10 records, and Silverlight part will need only to show number of the page and records itself.