how to delete many rows in the same time

dede26589

hi,
how to delete many rows in the same time ?
Thanks in advance

tangerine

Are you using DataTables Editor? If so, why not look at the examples?

https://editor.datatables.net/release/DataTables/extras/Editor/examples/fieldDefaults.html

dede26589

no not the editable table , a simple table

allan

In 1.9- use fnDeleteRow with the redraw parameter set to false and then loop over each row to be deleted. Once the loop has ended, use fnDraw to redraw the table.

In 1.10 you will be able to use `rows().remove()` to delete multiple rows.

Allan

xiaoyuandlg

I don't know this snippet of deleting rows in C# can be insightful or not for you:
[code]
this.ketticGridView.RemoveRows(rowToDelete);
this.ketticGridView.RemoveRowsAt(0)
this.productsTableAdapter.Update(this.nwindDataSet.Products);
[/code]
Although not the JS, really hope it helps.

http://www.kettic.com/winforms_ui/csharp_guide/gridview_row_remove.shtml

dede26589

i knew fnDeleteRow function, i use it but it is very slow

allan

DataTables 1.10 has a `rows().remove()` method which will give the ability to delete multiple rows at the same time.

Allan

allan

Oops - sorry, I just realised I'd said that in my last comment. Sorry for the duplicate :-).

Allan

dede26589

the solution is to add null and false :

fnDeleteRow(rownumber,null,false );


http://datatables.net/forums/discussion/comment/7585

allan

Remember to call fnDraw after you complete your loop.

Allan