Check are there rusults from the server

[noName]

JS:

var dm = ej.DataManager({

    url: "/Home/get", crossDomain: true,

    updateUrl: '/Home/update',

    adaptor: new ej.UrlAdaptor()

});

$("#Grid").ejGrid({

    dataSource: dm,

    allowScrolling: true,

    allowVirtualScrolling: true,

    filterSettings: {

        filterType: "menu"

    },

    pageSettings: { enableQueryString: true, pageSize: 10 },

    columns: [

        { field: "data", headerText: "Data", isPrimarykey: true },

        { field: "value", headerText: "Value" },

    ]

});

I want to check if there are results from the server and if there are create/show grid.

How can I check that ?

[Renjith Singh Rajendran]

Hi Customer, 

We have analyzed your query. We have achieved your requirement by using DataManager “executeQuery” and the jQuery “done” method. The done function is called for each successful post. We have checked a condition for the data returned from server. If no data is returned, the Grid won’t be rendered. If the dataSource is not empty, Grid will be renedered. Please refer the sample below, 

<script type="text/javascript"> 

    $(function () { 

        var dataManager = ej.DataManager({ url: "UrlDataSource", adaptor: new ej.UrlAdaptor() }); 

        var query = ej.Query().take(3); 

        var execute = dataManager.executeQuery(query)  

                .done(function (e) { 

                    if (e.actual.result.length) {         

                        $("#Grid").ejGrid({ 

                            dataSource: e.actual.result, 

                            ... 

                        }); 

                    } 

                }); 

    }); 

</script> 

Please refer the documentation link below, 

Link : https://help.syncfusion.com/js/datamanager/data-adaptors#url-adaptor 

We have also prepared a sample based on your requirement, which can be downloaded from the link below, 

Link : http://www.syncfusion.com/downloads/support/directtrac/general/ze/ejGrid-256538478.zip 

Regards, 

Renjith Singh Rajendran. 

[noName]

Hi, thanks. It works, but in this way I am loosing infinity scroll. How can I set it back with your example ? Infinity scroll works if I set:

dataSource: dataManager

, but I think this is second request.

[Renjith Singh Rajendran]

Hi Customer, 

Query 1: I am loosing infinity scroll 

 

In our last update we have not included the “allowVirtualScrolling” property of Grid. This is the reason for infinity scroll not enabled. Please refer the sample below, 

<script type="text/javascript"> 

    $(function () { 

         ... 

         $("#Grid").ejGrid({ 

            ... 

           allowScrolling: true, 

            scrollSettings: { height: 200, allowVirtualScrolling: true }, 

            ... 

         }); 

         ... 

   }); 

</script> 

Please download the modified sample from the link below, 

Link : http://www.syncfusion.com/downloads/support/directtrac/general/ze/ejGrid-833586047.zip 

And also in the code example provided by you, the allowVirtualScrolling was not provided in proper format. The allowVirtualScrolling must be inside the scrollSettings property of Grid. 

Query 2: Infinity scroll works if I set: dataSource: dataManager 

 

In the provided sample, we have bound the JSON Data to the Grid. If you need to load the data on demand while scrolling you can bind dataManager to the dataSource. Please refer the code below, 

<script type="text/javascript"> 

    $(function () { 

         var dataManager = ej.DataManager({ url: "Home/UrlDataSource", adaptor: new ej.UrlAdaptor() }); 

         ... 

         $("#Grid").ejGrid({ 

            dataSource: dataManager,             

            ... 

         }); 

         ... 

   }); 

</script> 

Regards, 

Renjith Singh Rajendran. 

[noName]

 By infinity scroll I mean load the data on demand while scrolling. Now I understand that I need to use 2 requests.

Ok, thx. Everything works.

[Mani Sankar Durai]

Hi Customer, 

We are happy to hear that your problem has been solved. 

Please let us know if you need further assistance. 

Regards, 

Manisankar Durai.