Remove datarow with linq

Question

I have a datatable in which I have the index number of the row that i want to delete using linq. I cant seem to get this to work properly because I am writing

int RowIndex = 3;  
DataTable.AsEnumerable().ToList().RemoveAt(RowIndex);
DataTable.AcceptChanges();

There is no error but it does not remove the row.

Your code removes that row from `List` instance that is created by `ToList()` call, not from the `DataTable` itself. — MarcinJuraszek, Feb 13 '14 at 20:27
possible duplicate of [Deleting specific rows from DataTable](http://stackoverflow.com/questions/5648339/deleting-specific-rows-from-datatable) — digEmAll, Feb 13 '14 at 20:29

score 4 · Answer 1 · answered Feb 13 '14 at 20:27

4

You don't need LINQ for this. Just remove it directly:

theDataTable.Rows.RemoveAt(rowIndex);
theDataTable.AcceptChanges();

answered Feb 13 '14 at 20:27

Reed Copsey

554,122
78
1,158
1,373

Remove datarow with linq

1 Answers1