Implement pagination with NHibernate ICriteria

I want to share my experience about implementing a pageable and sortable grids using NHibernate ICriteria. Many web applications use grids as a common representation of search results or list of data required by some business rules. We can extract data from database and paginate or order the records on the server side, but this creates a list of limitations in ordering the records and a big