Telerik c# MVC Grid customizing Paging with Custom sql query + Dapper

-
Telerik Mvc Web framework has an option to customize the paging of the grid.In most of the cases we are leaned towards to use its default option of paging/filtering.But It actually take all the data and filter or page or sort on top the all content from the back end ,this is the performance breach .

Here I am trying to describe the ways we can customize the Telerik   Mvc Paging without taking the bulk data.

There are 3 steps to do.
1.Make the telerik grid settings for the customization
2.Get the total count of data in the initial request.
3.Apply custom filter queries to filter from the back end.

1.Make the Telerik grid settings for the customization
Here is  a sample code to set up the grid with custom paging :


Here please note the Total we set after the ajax option.This value we need to get from the controller using Viewbag or any other data transfer methods to let the grid know the total.
.EnableCustomBinding true.

 Set the data read option

 In controller Read action,We will get the datasource object from there,we can extract the page number size filter etc.So according to these values we can extract /filter data from Db.

Sample code for Controller Read :



Make the Filter logic from the request and you can pass the page number and page size to filter from the data. Return the data source request with the total,and filtered data.Make sure the total amount to set in the data source object which returns back.

Sample Dapper query I used to get the desired amount of data :


Sample working example is given below:




That's all.Please comment If you have any query.

Happy Programming!!

#Telerik #Microsoft #Mvc #Dapper

Comments

Post a Comment

Popular posts from this blog

Configure Facebook Webhook[WebSub protocol]

-
Image
Facebook added  a product called Webhooks for subscribe to the changes and receive updates in real time without calling the API.This blog is about how to configure the webhook product in Facebook and integrate it in the ASP.net Application. Webhooks are basically works with the protocol named as  WebSub   , which contains three main components  Publisher. Subscriber. Hub. In the case of facebook webhook,the user who wants to get notification while new post comes in page is the subscriber.Publishing and hub part will handle by Facebook itself. Configure the end point in Asp.net Web API Create the asp.net application . Create get/post end points for Facebook like below: Here,get end point will get called once you subscribe to the Facebook webhook with hub.challenge token.You should echo back with the same for verification purpose.Post is the end point you are exposing to get notified on updates. You can get the complete cod...
Read more

SendGrid Integration with c#

-
Image
SendGrid is one of the way to send mail through the application which gives the statics on the emails send through the email server.There are two ways to configure mail client through the send grid. 1.STMP server 2.Through the API Send grid Event notification will give the notifications on the email activity happened like bounces,clicks,opens etc to get the potential reach of the email send via send grid which is a very cool option if you are working with some marketing related application.Let's see how to do this. Configure SendGrid 1.Set up an account with send grid. 2.In the start up guide you can configure the SMTP server or the API. 3.Select the WEB API  option and generate Api key and keep the API key with you. 4.To set up SMTP,choose the option and create new key for the SMTP server like below. Note down the username,generated key,Server name,Port also. Now we are done with send grid set up. Integrate in C# Code 1.Create a asp.net web api a...
Read more