Data Sources for Kendo Grid

4 posts, 0 answers
  1. Charles
    Charles avatar
    11 posts
    Member since:
    Jun 2018

    Posted 15 Oct 2018 Link to this post

    What .Net Objects can be used as  a data source for the Kendo Grid?

    Of those objects, are there preferred objects?

    Do some types of data source offer better performance than others?  What are they?

    We have a grid that will be getting data from comma-delimited files.  Many of these files may contain 100k or more records, so databinding and control rendering

    performance must be high/optimal.

  2. Boyan Dimitrov
    Admin
    Boyan Dimitrov avatar
    2062 posts

    Posted 17 Oct 2018 Link to this post

    Hello,

    In terms of working with large sets of data I would definitely recommend using server operations in order to work with a relatively small subset of data on the client side. This will guarantee highest performance since the data loaded in the DataSource/Grid are not many. I would suggest to take a look at the: 

       - https://demos.telerik.com/kendo-ui/grid/remote-data-binding demo. ServerPaging, serverSorting and serverFiltering are enabled in order to reduce the data items in the DataSource on the client-side. 

       - Also I would suggest to check the serverPaging, serverSorting and serverFiltering api docs with the examples. 

       - When working with .net object I would suggest working with  IQueryable  collections. 

    Regards,
    Boyan Dimitrov
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  3. Charles
    Charles avatar
    11 posts
    Member since:
    Jun 2018

    Posted 17 Oct 2018 in reply to Boyan Dimitrov Link to this post

    Thanks.  That's helpful.

     

    I could use some clarification. You posted:

    >>When working with .net object I would suggest working with  IQueryable  collections. 

    Does this mean any object that inherits or implements IQueryable is the preferred object to use as a data source? Would this be preferable to JSON?

     

     

     

  4. Boyan Dimitrov
    Admin
    Boyan Dimitrov avatar
    2062 posts

    Posted 19 Oct 2018 Link to this post

    Hello,

    In general the actual binding of data is performed on the client-side, so basically the Kendo UI Grid is populated with JSON objects either way. My post was an extra help for you when you start implementing the logic on the server. Since you mentioned that the Kendo UI Grid will work with large amount of data I would suggest to use IQueryable to increase the performance to take advantage of executing queries against the data on data base level. 

    I would suggest to take a look of the Kendo UI Grid demos for better getting started experience. 

    Regards,
    Boyan Dimitrov
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top