.NET DataTable skips rows on Load(DataReader)

by

After fiddling around quite a bit I found that the DataTable.Load method expects a primary key column in the underlying data. If you read the documentation carefully, this becomes obvious, although it is not stated very explicitly.

If you have a column named “id” it seems to use that (which fixed it for me). Otherwise, it just seems to use the first column, whether it is unique or not, and overwrites rows with the same value in that column as they are being read. If you don’t have a column named “id” and your first column isn’t unique, I’d suggest trying to explicitly set the primary key column(s) of the datatable before loading the datareader.

More Related Contents:

  1. Is datareader quicker than dataset when populating a datatable?
  2. How to convert json into datatable?
  3. Fastest way to convert datatable to generic list
  4. Difference between decimal, float and double in .NET?
  5. Why does WPF support binding to properties of an object, but not fields?
  6. How do you effectively model inheritance in a database?
  7. Why/when should you use nested classes in .net? Or shouldn’t you?
  8. Calling 32bit Code from 64bit Process
  9. ArgumentNullException or NullReferenceException from extension method?
  10. How to make modal dialog in WPF?
  11. Determine file type of an image
  12. How do you enable “Enable .NET Framework source stepping”?
  13. Questions every good .NET developer should be able to answer? [closed]
  14. How to get folder path for ClickOnce application
  15. .net ORM Comparison [closed]
  16. memory allocation of value types and reference types in .net framework
  17. How to cancel a long-running Database operation?
  18. Identifying the client during a .NET remoting invocation
  19. ERROR : [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
  20. What’s the difference between a dependency property and an attached property in WPF?
  21. Could not load type from assembly error
  22. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  23. Can/Does WPF have multiple GUI threads?
  24. Remove Highlight Effect from ListViewItem
  25. Why are try blocks expensive?
  26. Assigning a value to ComboBox Items
  27. Concatenate strings instead of using a stack of TextBlocks
  28. String.Split VS. Regex.Split?
  29. How to package a .NET Framework library? [closed]
  30. Overloading,Overriding and Hiding? [closed]

Leave a Comment