PivotGrid or KendoUI Grid ?

5 posts, 0 answers
  1. Philippe
    Philippe avatar
    6 posts
    Member since:
    May 2013

    Posted 15 Jan 2015 Link to this post

    Hello,

    We have to deal with a large amount of data from an Nhibernate queryOver (about 40.000 to 1.000.000 rows).
    We need to show this data as a pivot grid restitution in our web app, and apparently, that kind of component would suits our needs.

    As we have a lot of data : 
    - Would it be better to use Server-side pivot grid instead of KendoUI component ?
    - Is it possible to do a dynamic skip/take with an Nhibernate query to avoid all data in memory by getting grid current settings like filter, order, paging ?
    - If this is not possible with Nhibernate, would it be with a simple SQL query ?

    Regards,
    Maxime LEMARE.

  2. Radoslav
    Admin
    Radoslav avatar
    1564 posts

    Posted 19 Jan 2015 Link to this post

    Hello Philippe,

    Could you please elaborate a bit more on your scenario? What do you try to achieve – a grid which looks like a pivot table where database columns are presented as rows (reverse order - vertical grid) or pure pivot table where the control generates a report based on the database data?

    In the first scenario you can use RadGrid controls as is described in the help topic above. Also you can use custom paging in order to execute operations on the database server.

    If you try to achieve the second scenario– pure pivot table you need to use ASP.NET RadPivotGrid component. The Kendo PivotGrid does not support paging or filtering when it is bound to source different than a cube.

    Looking forward for your reply.

    Regards,
    Radoslav
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Au
    Au avatar
    4 posts
    Member since:
    Sep 2014

    Posted 19 Apr 2015 in reply to Radoslav Link to this post

    I need to display a grid which looks like a pivot table with the data returned from the server in JSON format (it seems the first scenario you mentioned above). How can I archive that? I don't use ASP.NET so cannot use RadGrid controls

  5. Radoslav
    Admin
    Radoslav avatar
    1564 posts

    Posted 22 Apr 2015 Link to this post

    Hello Au,

    You can try returning the json manually by calling your service and then transform in to the client or creating a new one based on the received which has rows as a columns. After that you can pass it as a datasoure of the kendo’s grid.  Please give it try and let me know if it helps you.
    Additionally please note that this thread is for RadGrid/UI for ASP.NET AJAX and to get opinion of the kendo experts you need to post your question in the kendoui forums or submit a ticket with kendo grid as a product.

    I hope this helps.

    Regards,
    Radoslav
    Telerik
     

    See What's Next in App Development. Register for TelerikNEXT.

     
  6. Au
    Au avatar
    4 posts
    Member since:
    Sep 2014

    Posted 22 Apr 2015 in reply to Radoslav Link to this post

    Hi Rado,

    Right after posting my previous question, I recognized that I should ask on Kendo UI forum instead of here but I cannot find a way to delete. I will try implementing as your suggestion. Thanks for your reply.

Back to Top
UI for ASP.NET Ajax is Ready for VS 2017