locked
CRM grid with paging on custom aspx page RRS feed

  • Question

  • Hi, I created a custom page with a DataList control to show data from CRM. I also have a textbox for search and would like to implement paging in a way that not all records from data source are being returned at once. I am considering to save QueryExpression and EntityCollection objects in a ViewState or cache (setting a reasonably small number for page size). Is this possible? Would any other approach be better?

    Thanks in advance

    
    Wednesday, September 24, 2014 1:33 PM

All replies

  • hello mate,

    I have not worked on this, but I saw an article by Scott (ribbon workbench fame), used sparkle xrm for his work on another tool. Is a js library.

    http://www.sparklexrm.com/s/features.html

    Jithesh

    Wednesday, September 24, 2014 9:37 PM
  • If using aspx, then the most efficient way would be to use CRM paging, in which case you only need to cache the PagingCookie (and page number) in aspx, rather than the whole EntityCollection. I'd suggest you store this in the Session object, to allow multiple users to have concurrent active searches

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Thursday, September 25, 2014 5:50 AM
    Moderator
  • Thanks for response, but don't I need EntityCollection's property - MoreRecords?

    Friday, October 3, 2014 10:52 AM
  • You would need to use the MoreRecords property; you'll need this to inform the user that there are more pages to get


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Friday, October 3, 2014 12:39 PM
    Moderator