How to make sure that all the data is not loaded into an existing table at once?

Question

ASP.NET

There is a table of 40 thousand + items.
There is an output of this table on View. Filters, sorting, etc.
I use Kendo.
The data in the table is loaded at once and all. Is it possible to make the data in the table loaded only by the filters used? (such as: how much to display per page and which page is open.)

Answer 1

Here is an example of how only the necessary data fragments are taken from the database:
https://metanit.com/sharp/mvc5/5.13.php
And so you need to create an action in the controller, which takes "filtering, sorting, page" as parameters and make queries to the database using them.