checks all checkboxes in the DataTable including hidden rows

Question

I'm trying to make a function that checks all checkboxes in the DataTable, including hidden rows. Here's the html code for the "checkbox" column: ```

	val1	val2	val3	val4	val5

``` Submit button: ``` ``` And the JQuery code that doesn't work: ``` $(function () { otable = $('#customersList').dataTable({ "bJQueryUI": true, "sPaginationType": "full_numbers", "aLengthMenu" : [ [10,20,50,100,1000], [10,20,50,100,1000] ], "iDisplayLength": 100, "bProcessing": true, "bServerSide": true, "aaSort…

Accepted Answer

Try:

```
$("#selectallboxes").click(function () {
    var selected = new Array();
    $(otable.fnGetNodes()).find(':checkbox').each(function () {
        $this = $(this);
        $this.attr('checked', 'checked');
        selected.push($this.val());
    });
    // convert to a string
    var mystring = selected.join();
    alert(mystring);
});
```

`.length` gives you the length of the array. I've used `join()` to join the array into a string. DataTable's `.fnGetNodes()` gives you all the rows in the table including hidden ones.

checks all checkboxes in the DataTable including hidden rows

Solution

Problem