how to get more than 100 records from JSON using Jquery

Kranthi Vardhan Kolluru

Hi,

i am developing an aspx page to get data from db using webmethod and convert into JSON string. Then i am passing this JSON string to JQuery and displaying the records in a HTMLtable.

Upto 90 records from database the functionality is working good when i cross 90 records from database i.e., i have 2000 records in the database table and i want to display 2000 records in the HTMLtable using this method. It is showing 500 error.

How can i get the all records from the database table ? is there any settings for JSON string ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg7y ago
Accepted answer
Hi.
I think you are exceeding with the json length and in that case you will receive 500 error.
Follow these article for more about json,
https://www.ibm.com/support/knowledgecenter/en/SS9H2Y_7.6.0/com.ibm.dp.doc/json_parserlimits.html

How To set the maximum value of json you can follow below article,
https://dotnet2developer.blogspot.com/2017/11/max-json-length-exceeded-error.html

Thanks.
0
Dinesh Gabhane7y ago
Basically 500 error is server error. I have some questions as below
1) Is all 2000 records getting from Database in your server side code?
2) If all records getting then Is this error coming while converting it to JSON?

where exactly you are getting error? can you post your code where you are getting error?
0