Jquery DataTables warning:requested Unknown from the data source for row 0

When I was doing Jquery DataTables yesterday, I encountered a problem that I used MVC and added a actionlink href to tables. But in the run up, the error:

DataTables warning:requested Unknown parameter ' 3 ' from the data source for row 0

By searching the online big God solution, so I put blogs on the solution to copy, this is the original link address http://seaboycs.iteye.com/blog/2015230

Hope to help meet the same problems of friends, but also for their work to summarize

Today encountered a DataTables common problems, engaged for a long time did not fix, check Baidu also no results, on Google found the reason.

Problem:

DataTables warning:requested Unknown parameter ' 3 ' from the data source for row 0

Js:

JS Code

2. function initializeevents () {
4. $ ('. DataTable '). DataTable ({
6. " sdom": "< ' Row-fluid ' < ' span6 ' l>< ' span6 ' f>r>t< ' row-fluid ' < ' span12 ' i>< ' Span12 Center ' p>> ',
8. "Bserverside": true,
10. " Sajaxsource": "/uploaddemo/admin/photo/list.spring",
12. " Sservermethod": "POST",
14. "bprocessing": false,
16. "Bpaginate": true,
18. "Blengthchange": true,
20. "Idisplaylength": Ten,
22. "fnadjustcolumnsizing": false,
24. "Bstatesave": false,
26. "Bsort":false,
28. "Bfilter":false,
30. "Aocolumndefs": Makecollumndef (),
32. "Aocolumns": Makecollomns (),
34. " spaginationtype": "Bootstrap",
36. "Olanguage": {
38. "Slengthmenu": "_menu_ records per page"
40. }
42. } );
44. }
46. function Makecollumndef () {
48. return [
50. { "Fnrender": function (Oobj, sval) {
52. return oObj.aData.id;
54. },
56. "bvisible": true,
58. "atargets": [0]
60. },
62. { "Fnrender": function (Oobj, sval) {
64. return oObj.aData.name;
66. },
68. "bvisible": true,
70. "Atargets": [1]
72. },
74. { "Fnrender": function (Oobj, sval) {
76. return "<img src= '/uploaddemo/" +oobj.adata.path +"' width=50px height=40px/>";
78. },
80. "bvisible": true,
82. "Atargets": [2]
84. },
86. { "Fnrender": function (Oobj, sval) {
88. return createaction (oObj.aData.id);
90. },
92. "bvisible": true,
94. "Atargets": [3]
96. }];
98. }
100. function Makecollomns () {
102. return [{ "Mdataprop": "id", "sheight":"15px"},
104. { "Mdataprop": "Name"},
106. { "Mdataprop": "Path"}}];
108. }
110. function createaction (ID) {
112. var inhtml = ' <a class= ' btn btn-success ' href= '/uploaddemo/admin/photo/view.spring?id= ' + ID + ' > ';
114. inhtml + = ' <i class= ' icon-zoom-in icon-white ' ></i>View</a> ';
116. inhtml + = ' <a class= "btn btn-info" href= "/uploaddemo/admin/photo/preupdate.spring?id= ' + ID + '" > ";
118. inhtml + = ' <i class= ' icon-edit icon-white ' ></i>Edit</a> ';
120. inhtml + = ' <a class= "btn btn-danger" href= "/uploaddemo/admin/photo/delete.spring?id= ' + ID + '" > ";
122. inhtml + = ' <i class= ' icon-trash icon-white ' ></i>Delete</a> ';
124. return inhtml;
126. }

Refer to the solution of https://gist.github.com/kagemusha/1660712, the Great god:

Meaning that the number of aocolumns and aocolumndefs must be equal, otherwise it will be wrong, because I added an Action column in the table, resulting in aocolumns and aocolumndefs the number of unequal, the above error, the method is relatively simple:

Add an arbitrary field to the Java Bean and add it to the aocolumndefs.

Java code

1. Public class Photobean {
3. private int id;
4. private String name;
5. private String path;
6. private String checked;

JS Code

1. function Makecollomns () {
2. return [{ "Mdataprop": "id", "sheight":"15px"},
3. { "Mdataprop": "Name"},
4. { "Mdataprop": "Path"},
5. { "Mdataprop": "checked"}];

I added a checked string to solve the problem.