Add / remove columns in datatables

Question

can the feature of add/ remove columns given in the footer of this example of jqgrid (by clicking on choose columns)

http://www.ok-soft-gmbh.com/jqGrid/SimpleLocalGridWithColumnChooser8.htm

can be applied on the datatables given in this link

http://datatables.net/examples/api/show_hide.html

what i am asking is can the same thing happen in datatable on a buttonclick event with almost same interface....

In datatable, there are toggle buttons outside the grid but in jqgrid, it opens a new window to add/ remove columns....

zanedev · Accepted Answer · 2012-12-18 17:10:18Z

2

According to the forums, Allan has said it is not currently supported so a workaround is it has to be done via one of two methods: 1) Populate the data with the new/removed column and refresh/redraw the table (more overhead) 2) For adding a column if your case is simple you could prepopulate a few extra empty hidden columns in the initial data and simply show them as they are added. (less overhead)

See these threads for more insight:

http://datatables.net/forums/discussion/12270/dynamically-addremove-columns-datatables-warning.-requested-unknown-parameter.../p1

http://datatables.net/forums/discussion/8418/possible-to-dynamically-remove-or-add-a-column/p1

answered Dec 18, 2012 at 17:10

zanedev

5686 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:30:55Z

1

jqGrid has hideCol and showCol methods which allows to hide or show column of the grid. The Column Chooser just provide more comfortable interface for the user to do the same. It allows additionally to change the order of the columns. If you want to have some other GUI for hiding (or showing) columns you can bind click event on any external links or buttons and to call hideCol and showCol inside of your implementation of the click event handler.

You can also consider to place additional buttons for hiding/showing directly in the column header like I described in the answer.

edited May 23, 2017 at 12:30

CommunityBot

11 silver badge

answered Sep 13, 2012 at 12:04

Oleg

222k36 gold badges414 silver badges826 bronze badges

2 Comments

Aryan Verma Over a year ago

but this example is for the jqgrid... how can i do the same in datatables.... can u please provide me some working example...

Oleg Over a year ago

@AryanVerma: I don't use datatables and don't know it. If you need a solution for datatable you should remove jqgrid tag from your question.

Collectives™ on Stack Overflow

Add / remove columns in datatables

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related