New rows can be added to a DataTable using the row.add() API method. Simply call the API function with the data for the new row (be it an array or object). Multiple rows can be added using the rows.add() method (note the plural). Data can likewise be updated with the row().data() and row().remove() methods. You can refer full documentation from here Datatables

  Add new row

After the table is initialised, the API is used to build the select inputs through the use of the column().data() method to get the data for each column in turn. The helper methods unique() and sort() are also used to reduce the data for set input to unique and ordered elements. Finally the change event from the select input is used to trigger a column search using the column().search() method.

DataTables has the ability to apply searching to a specific column through the column().search() method (note that the name of the method is search not filter, since filter() is used to apply a filter to a result set).

It can be useful to provide the user with the option to select rows in a DataTable. This can be done by using a click event to add / remove a class on the table rows. The rows().data() method can then be used to get the data for the selected rows. In this case it is simply counting the number of selected rows, but much more complex interactions can easily be developed.

Row count

In order to perform paging, ordering, searching etc, DataTables can remove rows and cells from the document (i.e. those rows / cells which are not needed are not inserted into the document). This increases performance and compatibility, however, it means that submitting forms which span multiple pages requires a little bit of additional work to get the information that is not in the document any longer.

Submit form

This example modifies the multiple row selection example by only allowing the selection of a single row. This is done by checking to see if the row already has a selected class, and if so removing it, but if not then the class is removed from all other rows in the table and then applied to the row being selected.

Delete selected row