How to create new row in middle of the data table

dhanu

Now I am able to create new row at end of the data table, but my intentions is evry row has one plus button is there, if user click the button then create next row of the table

Please help

allan

This has come up a number of times already. Just typing your post title into the search box yields lots of relevant results: http://datatables.net/search?cx=004673356914326163298%3Abcgejkcchl4&cof=FORID%3A9&ie=UTF-8&q=How+to+create+new+row+in+middle+of+the+data+table&sa=Search&siteurl=datatables.net%2Fforums%2F&ref=&ss=7j49j2

Allan

dhanu

Thanks, Allan.
My question, after adding new row, rows counts are updated in pagination but not visible in table.
anything missing

dhanu

$(document).ready( function () {

$("#sellIn").dataTable({

"sPaginationType": "full_numbers",
"bPaginate": true,
"bJQueryUI": true,
"bAutoWidth": true,
"bFilter": false,
"bSort":false,
//"aaSorting": [[0,'asc']],
//"aaSortingFixed":[ [0,'asc']], // to force sorting for first column
"aoColumnDefs": [
{ "bSortable": false, "aTargets": [ 0 ] }
]
//"aaSorting": [[1, 'asc']]
});

var oTable = $("#sellIn").dataTable();
var oSettings = oTable.fnSettings();
var oData = $('#sellIn').dataTable().fnSettings().aoData;
var oDisplayMaster = $('#sellIn').dataTable().fnSettings().aiDisplayMaster;
var oDisplay =$('#sellIn').dataTable().fnSettings().aiDisplayMaster;
var affectedRowNbr = 1; //childTd.parentNode.parentNode.rowIndex-1;
var ind = affectedRowNbr+1;
//var aData = oData[affectedRowNbr]._aData;
var newRow = " ";
newRow += "test0test1test2test3test4test5";
newRow += "";
//var newRowData = $(newRow)[0];
var nTr = $(newRow)[0];
var nTds = nTr.getElementsByTagName("td");
var aData = [];
for ( var i=0 ; i

allan

Please link to a test case using JSFiddle, CodePen, http://live.datatables.net or your own site, showing the problem.

Allan

dhanu

http://live.datatables.net/idinat/1/edit

dhanu

Are you able to see my code

dhanu

http://jsfiddle.net/dhanu/C5z86/

allan

Yes thank you.

You are modifying DataTables internal variables in the settings object. Modifying these values externally is absolutely not supported. You need to be very careful when doing that, since it will have knockout effects. Also be aware that the settings object can, will and does change between versions.

If you want a row to be inserted into a specific location in the table, use the ordering options the table provides. That is the only form of row ordering DataTables supports.

Allan

dhanu

Thanks Allan,
I tried same as ordering dataTables but not working.
any other solution is there

allan

No - ordering is the only solution for defining ordering in a DataTable.

Allan