Deleting middle rows in dataTable

Give a try on following:

Assign Activity
LHS: dtReduced | DataType: DataTable
RHS:
dt.AsEnumerable.Where(Function (x,i) i < 5 or i > dt.Rows.Count - 6).CopyToDataTable

dt = your Origin DataTableVar

2 Likes