Search

You would need to bind a blur event to your text box and then use the fnUpdate method to update the cell. Allan

Thanks for your reply, Allan. Whilst I understand some of your reply, I can't seem to put it in to practice. Upon searching the forums some more I come across this thread: http://datatables.net/forums/discussion/1581/problem-to-adding-a-custom-column/p1 Which seems to be part of what I'm looking for, however it seems that this is for an older version of DataTables. Is: [code]$sOutput .= '"column value",';[/code] still working/allowed to be used? Because I've managed to add the additional column heading called 'options'. I figure for each [code]$sOutPut[/code] I add would be an additional column? So theoretically I could do the following: [code]$sOutput .= [/code]

Allan, unfortunately going the DOM route is going to make it so that I have to rewrite all methods for save, restore, edit, etc. I have to do this because using jquery and the dom when edit/save/restore rows are called it has no idea of the data because fnGetData. Thanks for the information I am going to be working on a rewrite for this that will not use the DT API. Unless it can be done using server side processing. The one thing I am having a bit of trouble understanding is how I will restore the row since the data will not be stored in the DT internal data. Upon clicking Edit row I think I need to create an array of the real data, that way restore row has the "real" data to restore.

Not quite following - you want to use 2'800 rows of data, but only have it use the 10 or so which it is actually displaying? But how then will it support sorting / filtering etc. DataTables itself needs to know about all of the data, or if using server-side processing, the server will need to perform all of the operations (which you say you can't do just yet). So I'm not quite clear on what you mean about using it like remote data, but it not being remote data? Allan

Is possible edit a cell and when press enter key pass to edit cell below?

I got the tab button to work with `var dataTable = $('#racedata').DataTable({ "processing" : true, "serverSide" : true, "keys" : true, "order" : [], "ajax" : { url:"fetch.php", type:"POST" } }); table.keys.enable( 'navigation-only' ); } ` How to i get the arrows keycode=38/40 to function? Please be so kind to advise

Solved

I want to be able to submit just after change. Is there a way in jQuery Datatable Editor to do this? http://debug.datatables.net/uzolop

In this table working good on desktop view in mobile view delete is not working proberly Name Position Office Extn. Start date Salary Action $(document).ready(function() { $('#example').DataTable( { "ajax": "demo.json", "columns": [ { "data": "name" }, { "data": "position" }, { "data": "office" }, { "data": "extn" }, { "data": "start_date" }, { "data": "salary" }, { "mData": null, "bSortable": false, "mRender": function(data, type, full) { return 'Delete'; } } ] } ); $(document).ready(function() { var table = $('#example').DataTable(); $('#example tbody').on( 'click', 'tr', function () { if ( $(this).hasClass('selected') ) { $(this).removeClass('selected'); } else { table.$('tr.selected').removeClass('selected'); $(this).addClass('selected'); } } ); $('#button').click( function () { table.row('.selected').remove().draw( false ); } ); } ); $("#example").on('click','.btnDelete',function(){ $(this).closest('tr').remove(); alert("SucessFull Delete data from DataBase U Cant Retrive This Data Again "); }); // Apply Form Button click show/hide $(function () { $('.toggle').click(function (event) { event.preventDefault(); var target = $(this).attr('href'); $(target).toggleClass('hidden show'); }); }); } );

I am loading my datatable via a server-side ajax call (serverside option set to true). However, I am overriding the Editor's ajax call to save edited data on client-side until the user presses a save button and all changes are submitted to the server at once. Therefore, I don't want the datatable to reload data from the server each time the Editor submits. Is there any way for me to prevent that?