We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Looking for server side pagination in Grid / DropDown List

Hi,

I would like to know that, is there any provision of Server side pagination in Grid, DropDown List or any of the control which pulls the data from database in list manner.

If yes, Please do let me know how can I use server side pagination.

Thanks in anticipation.
Manish

2 Replies

MA Manish December 21, 2015 09:33 AM UTC

Hi,

Can you please help me out?


SA Saravanan Arunachalam Syncfusion Team December 21, 2015 11:28 AM UTC

Hi Manish,

Thanks for contacting Syncfusion support.

Query 1: Server paging on Grid control.

We analyzed your query and you can perform the Grid operation (paging, sorting,.) on server side by using “URLAdaptor” of ejDataManager. The paging operation of Grid performed on the server side by the Skip and Take property of DataManager class. Please refer to the below code example, online documentation link and online sample link.

                                         

[View]

@(Html.EJ().Grid<object>("Editing")

    .Datasource(ds=>ds.URL("DataSource").Adaptor(AdaptorType.UrlAdaptor))

[Controller]

public ActionResult DataSource(DataManager dm)

        {

            . . .

            //server side paging

            if (dm.Skip > 0)

                result.result = operation.PerformSkip(result.result, dm.Skip);

            if (dm.Take > 0)

                result.result = operation.PerformTake(result.result, dm.Take);

            return Json(result, JsonRequestBehavior.AllowGet);

        }

 

https://help.syncfusion.com/js/grid/editing#url-adaptor

https://mvc.syncfusion.com/demos/web/grid/batchediting

Query 2: Server paging on Dropdown list.

Currently we don’t have support for paging in Dropdown control. We have logged as a feature and a support incident has been created under your account to track the status of this feature. Please log on to our support website to check for further updates.

https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents 

But we have Virtualization support with Dropdown based on scroll, the online demo is available in the following link

https://asp.syncfusion.com/demos/web/dropdownlist/virtualscrolling.aspx


Regards,

Saravanan A.


Loader.
Up arrow icon