Kendo Grid Integration Using jQuery

Kendo Grid Integration Using jQuery


Introduction

In this article, we will learn about the very powerful Kendo Grid by Telerik that provides rich inbuilt features with less coding. We integrate the kendo grid using jQuery. Kendo can be used with any modern technology, such as  - ASP.ET WebForm, ASP.NET MVC, .NET Core MVC, Node.js, PHP etc.

Prerequisites
  1. Visual Studio Code or any Text Editor
  2. Web Service or Web API
For this demo, I have used the web service created and hosted by Telerik. Source code for this web service is open source that you can review on GitHub as well.

NoteKendo Grid is a licensed version.

DescriptionAs we know, each and every application requires any tabular format to display small or large data with basic functionality, like Grid with Sorting, Filtering, Paging etc.

Here, the Kendo Grid provides the above functionality along with other advanced and powerful inbuilt features as mentioned below.
  1. Column Reordering
  2. Column Resizing
  3. Excel-Like filter menu which contains(Start With, End With, Contains, Not Contains. Equal to, Not equal to etc filter action)
  4. Hide or show column
  5. Keyboard navigation
  6. Row grouping
  7. Paging with Server and client-side 
  8. Row or cell selection and Copy selected rows or cells in the clipboard with (Ctrl + C)
  9. Change detection in Cell Edit mode or batch edit mode
  10. Persistent selection of rows while sorting and filtering
  11. Export data to excel, pdf etc
  12. Inbuilt CRUD Operation with different edit mode like inline, popup, in cell etc
  13. Inbuilt themes or skin
  14. Support multiple form control e.g. DateTime, Textbox, Numeric, Checkbox, Dropdown etc
  15. Built-in validation as well.
  16. Frozen or lock column
CRUD operation and other advanced features will be explained in the next article. I have tried my best to cover as many as possible features   in this article.

Step 1 Add Kendo UI CSS and JS along with jQuery UI and Add selector in HTML page so we can bind the grid to that element.

Step 2 Prepare, configure, and initialize Kendo grid feature to DOM element (#grid). Take a look,
The above script needs to be wrapped in script tag.

As per the above JavaScript code, you can easily configure most of the features with less code by just setting a specific property to it. I have tried to add possible or required comments to the above code snippet to make it more understandable.

Once you add the above code, it will show an output like the below screenshot which contains toolbar options, Row grouping on Country and City Column with Sorting, interactive Paging and Excel-like filter (three dots in column header).

You can see implemented feature of Kendo grid.


Reference links
  • https://demos.telerik.com/kendo-ui/grid/index
  • https://demos.telerik.com/kendo-ui/grid/column-reordering 
Conclusion

In this article, we have learned how to integrate Kendo Grid using jQuery UI with an in-built feature with easy configuration.


I hope you like this article.

No comments:

Post a Comment

Dynamic Query in LINQ using Predicate Builder

Introduction This tutorial explains how to create a dynamic query using LINQ, Using Predicate Builder  LINQ to SQL dynamic query an...

Learn More