This is a migrated thread and some comments may be shown as answers.

Kendo Grid not showing data over 285 records

4 Answers 1268 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Wiki
Top achievements
Rank 1
Wiki asked on 07 Aug 2012, 05:12 PM
Hi,
Please help me out from this issue.
my kendo grid is not showing data over 285 records. i dont know why it is doing that. but i can tell you my code.
i m using kendo grid with asmx web services. JSON is the data type.
i checked my service that it is calculating fine and sending data is also fine. but after send, kendo grid not showing it. if I limit the data to 100 or 200 rows then it shows but over this limit it is showing a blank screen.
I want to show over 10,000 rows and not to use virtual and paging.

CODE SAMPLE :
$("#SearchGrid").kendoGrid({
        height: 820,
        selectable: true,
        groupable: true,
        filterable: true,
        sortable: true,
        columns: [
                    { field: "PartNo", title: "Part", width: "40px" },
                    { field: "NewNo", title: "New No", width: "40px" },
                    { field: "PartDesc", title: "Desc", width: "50px" },
                    { field: "WH_31", title: "31", width: "20px" },
                    { field: "WH_32", title: "32", width: "20px" },
                    { field: "WH_34", title: "34", width: "20px" },
                    { field: "WH_35", title: "35", width: "20px" },
                    { field: "WH_36", title: "36", width: "20px" },
                    {field: "MinRate", title: "Rate", width: "20px" },
                    { field: "Grade", title: "ABC", width: "20px" },
                    { field: "LocationCode", title: "BIN", width: "20px" }
                ],
        dataSource: {
            schema: {
                model: {
                    id: "PartID"
                },
                data: "d"
            },
            transport: {
                read: {
                    url: "abc.asmx/Status",
                    contentType: "application/json; charset=utf-8",
                    type: "POST",
                    dataType: "json"
                },
                parameterMap: function (data, operation) {
                    return JSON.stringify({ PartNo: part, Group: GROUP, Code: info })
                }
            }
        }
    });
}

Please help me out

4 Answers, 1 is accepted

Sort by
0
Wiki
Top achievements
Rank 1
answered on 07 Aug 2012, 05:38 PM
I turned ON the Error reporting and it says
"Internal Server Error"
I cant understand what is that? because service is woring fine alone.
Please me out...
Thanks
0
Wiki
Top achievements
Rank 1
answered on 03 Sep 2012, 12:57 PM
Is Kendo Team sleeping or something busy?
I posted this thread a month ago and kendo team dont even try to ans my Post.. I am using kendo for 6 months and you guys are not tolerating with me.

Kindly, reply me why kendo grid is not showing data over 300 or some limited amount of size...!!!
Is there any size issue with json returned string?

kindly, help me... my alot of work is pending due to this issue...

Here i repeat, i am using kendo grid with ASMX webMethod.

Thank You in advanced.
0
Wiki
Top achievements
Rank 1
answered on 19 Sep 2012, 05:19 AM
At last .. i found the solution myself..
First of All, ASP.NET cannot transfer json data above 100k by default.. but we can extend its limit by adding these lines into Web.config file under <configuration> tag....!!!

  <system.web.extensions>
    <scripting>
      <webServices>
        <jsonSerialization maxJsonLength="50000000"/>
      </webServices>
    </scripting>
  </system.web.extensions>

this will extend the limit of json transfer size.

Next problem was, when i load kendo grid on the same div two or more times.. it gives error of " d. data is not defined" while editing.
So, the solution is: Dont load kendo grid on static div. each time the call goes to kendo grid. append a dynamic div in static div and apply kendo grid on it. and after next call to same page on same kendo grid. remove the previous dynamic div. append new one and apply kendoGrid on it.
it will helps on editing.
following is the example:

<div id="grdLPO"></div>
<script type="text/javascript">
            function LoadGrid() {

            $("#LPO").remove();
            $("#grdLPO").append('<div id="LPO"></div>');
            $("#LPO").kendoGrid({ ........ });
            }
</script>

hope it helps .:x:.
0
Ramprasad
Top achievements
Rank 1
Iron
answered on 22 Feb 2023, 08:15 AM

You should add the following lines at the end of your controller method while returning the JSON data.

DataSourceResult result = objTestModel.lstTestData.ToDataSourceResult(request);

var dataResult = Json(result, JsonRequestBehavior.AllowGet);
dataResult.MaxJsonLength = int.MaxValue;
return dataResult;
Tags
Grid
Asked by
Wiki
Top achievements
Rank 1
Answers by
Wiki
Top achievements
Rank 1
Ramprasad
Top achievements
Rank 1
Iron
Share this question
or