How to get columns names of jquery:datatable where the columns are created dynamically?

ErayBalkanli
February 1, 2023
61 views
0 votes
2 Answers

I have a jquery:datatable in my code where its columns are created dynamically in the C# based on some table records in SQL.

In this datatable, I use a custom button called "Save". I need to get the column names of the table here as I get the data in the rows but I couldn’t find the correct syntax to get the column names.

...
text: 'Save',
action: function (e, dt, node, config) {
          var json = JSON.stringify(dt.rows().data().toArray());
          // how to get the columns??
          // probably I need to use dt.columns().header() at some point?
        }
...

I believe I need to use dt.columns().header() as it gives me tags with a lot of info, not sure how I can retrieve column name over there.

Any help would be appreciated.

Answers

Chosen as BEST ANSWER
- ErayBalkanli
- February 1, 2023 at 5:46 pm
- 0 votes
0
I've found my own answer. Here it is:
```
var cols = ""

dt.columns().header().each(function (e, i) {
       var col = jQuery(e).html();
       cols += col + ",";
});
```
Thanks.