Deleting specific rows from DataTable

by

If you delete an item from a collection, that collection has been changed and you can’t continue to enumerate through it.

Instead, use a For loop, such as:

for(int i = dtPerson.Rows.Count-1; i >= 0; i--)
{
    DataRow dr = dtPerson.Rows[i];
    if (dr["name"] == "Joe")
        dr.Delete();
}
dtPerson.AcceptChanges();

Note that you are iterating in reverse to avoid skipping a row after deleting the current index.

More Related Contents:

  1. DataTable, How to conditionally delete rows
  2. Easiest way to split a string on newlines in .NET?
  3. Compiler Ambiguous invocation error – anonymous method and method group with Func or Action
  4. Why does the order of alternatives matter in regex?
  5. Can’t add script component because the script class cannot be found?
  6. How to load the RSA public key from file in C#
  7. How to easily initialize a list of Tuples?
  8. What is the difference between Server.MapPath and HostingEnvironment.MapPath?
  9. Why can’t I access C# protected members except like this?
  10. WCF ServiceHost access rights
  11. Multi Value Dictionary?
  12. Why C# won’t allow field initializer with non-static fields?
  13. How do I ignore the UTF-8 Byte Order Marker in String comparisons?
  14. Cleanest Way to Invoke Cross-Thread Events
  15. Step by step tutorial to use SAP. net Connector with VS 2008 [closed]
  16. WPF ListView: Attaching a double-click (on an item) event
  17. Changing a label’s text in another form in C#?
  18. Binding SelectedItems of ListView to ViewModel
  19. CryptographicException was unhandled: System cannot find the specified file
  20. How to serialize an Exception object in C#?
  21. How can I get date and time formats based on Culture Info?
  22. The extern alias ‘xxx’ was not specified in a /reference option
  23. ThreadStaticAttribute in ASP.NET
  24. What is the equivalent of Java wildcards in C# generics
  25. Deploy C# ActiveX in a CAB for Internet Explorer use
  26. WPF TwoWay Binding to a static class Property
  27. how to check if List element contains an item with a Particular Property Value
  28. How to show form in front in C#
  29. Parse XML document in C#
  30. Custom Color Palette in Visual Studio Color Property Editor

Leave a Comment