DataTable, How to conditionally delete rows

by

You could query the dataset and then loop the selected rows to set them as delete.

var rows = dt.Select("col1 > 5");
foreach (var row in rows)
   { row.Delete(); }
   dt.AcceptChanges();

… and you could also create some extension methods to make it easier …

myTable.Delete("col1 > 5");

public static DataTable Delete(this DataTable table, string filter)
{
    table.Select(filter).Delete();
    return table;
}
public static void Delete(this IEnumerable<DataRow> rows)
{
    foreach (var row in rows)
        row.Delete();
}

More Related Contents:

  1. Convert generic List/Enumerable to DataTable?
  2. How to read a CSV file into a .NET Datatable
  3. Convert JSON to DataTable
  4. Convert IEnumerable to DataTable
  5. Inner join of DataTables in C#
  6. How To Change DataType of a DataColumn in a DataTable?
  7. Best way to remove duplicate entries from a data table
  8. How I can filter a Datatable?
  9. Deleting specific rows from DataTable
  10. How to select min and max values of a column in a datatable?
  11. Compare two DataTables to determine rows in one but not the other
  12. Export DataTable to Excel File
  13. How to compare 2 dataTables
  14. How to create a DataTable in C# and how to add rows?
  15. Convert DataTable to generic List?
  16. Creating a SQL Server table from a C# datatable
  17. Datatable vs Dataset
  18. Convert DataTable to IEnumerable
  19. Data is visible in DataSet visualizer but does not show in a DataGrid
  20. Best way to check if a Data Table has a null value in it
  21. Datatable to html Table
  22. Best Practice: Convert LINQ Query result to a DataTable without looping
  23. Get Cell Value from a DataTable in C#
  24. How to change DataTable columns order
  25. How do I loop through rows with a data reader in C#?
  26. How to convert DataTable to class Object?
  27. Replacing a DataReader with a DataTable
  28. How can I convert a DataTable to an XML file in C#?
  29. How do you Sort a DataTable given column and direction?
  30. Convert DataTable to Generic List in C#

Leave a Comment