Click here to Skip to main content
15,892,674 members
Please Sign up or sign in to vote.
1.00/5 (3 votes)
How to load large data in bootstrap table please anyone please help me I have to load 50000 row on load time.

What I have tried:

I have tried but only 7000 row is loading at a time.
Posted
Updated 26-Sep-18 5:53am
v2
Comments
OriginalGriff 26-Sep-18 10:15am    
How do you expect us to help you when we have no idea what you tried, how you tried, it, or what happened when you did?

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with.
Give us relevant code fragments, give us error messages, give us something to work with!

Use the "Improve question" widget to edit your question and provide better information.
prakash00060 27-Sep-18 4:59am    
i am not telling about 50000 row in one page or without pagination. I have check only 7000 data is loaded in 250 pagination.Understand the questions. have you any option to manage 50000 data at a time with pagination. when i load 10000 data a time it gives error serilization and deserilization limit is exceed.I set maxLimitlength is maxinteger length.
OriginalGriff 27-Sep-18 5:04am    
Read what I said: I didn't mention paging, I just told you that you haven't given us enough info to help you...
prakash00060 27-Sep-18 8:25am    
sir my database is very large and requirement is to load all data at a time.
when i load all data it gives error serilization and deserilization limit is exceed.
I set in webconfig
<httpRuntime targetFramework="4.6.2" maxRequestLength="2147483647" executionTimeout="600" />

jQuery.ajax({
url: '@Url.Action("GetCandidateData", "Home")',
type: "POST",
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function (data) {
debugger;
//alert();
$('#tableboot').bootstrapTable('load', JSON.parse(data));
},
failure: function (data) {
debugger;
alert(data.responseText);
},
error: function (data) {
debugger;
alert(data.responseText);
}
});
});
Richard Deeming 28-Sep-18 6:59am    
"requirement is to load all data at a time"

Then the requirement is wrong.

As I said, nobody is going to scroll through thousands of records to find the one they want. Use pagination and filtering to let them find the record they want without loading your entire database at once.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900