title: Bind a database table with Kendo Grid (MVC) using stored procedure, with large amounts of data with proper server side paging, sorting, filtering
body: <p>We have a table with a large amount of data (in the millions of rows). We are using a stored procedure to fetch the records and binding that data with kendo grid using mvc approach. But we want to fetch only desired rows from table instead of getting the whole set of data in one go and then make filtering, sorting, paging options on that.</p>
  
  <p>Would it be possible to fetch only one page of rows at a time? Please help and suggest some approach.</p>