I have my solution setup as follows (image also attached):
Data <--> Business <--> WCF Service <--> Intranet <--> WCF Client <--> Website
I have attempted to implement paging but it is not the most optimal way. Here is the code that starts with the website and ends in the Data Layer:
It seems that the data on the grid is not changing when changing page and everytime, I'm reading the whole data just to get a new page. Is there a better way to do this?