This Row already belongs to another table error when trying to add rows?

by

You need to create a new Row with the values from dr first. A DataRow can only belong to a single DataTable.

You can also use Add which takes an array of values:

myTable.Rows.Add(dr.ItemArray)

Or probably even better:

// This works because the row was added to the original table.
myTable.ImportRow(dr);

// The following won't work. No data will be added or exception thrown.
var drFail = dt.NewRow()
drFail["CustomerID"] = "[Your data here]";
// dt.Rows.Add(row); // Uncomment for import to succeed.
myTable.ImportRow(drFail);

More Related Contents:

  1. How to implement a pipeline?
  2. Send values from one form to another form
  3. Create a strongly typed c# object from json object with ID as the name
  4. C# DateTime to “YYYYMMDDHHMMSS” format
  5. Factory method with DI and IoC
  6. Nested using statements in C#
  7. How to stop C# console applications from closing automatically? [duplicate]
  8. Saving/loading data in Unity
  9. Convert an image (selected by path) to base64 string
  10. Attach a file from MemoryStream to a MailMessage in C#
  11. Must declare scalar variable @Id?
  12. How do I generate a random integer in C#?
  13. How can I cast int to enum in C#?
  14. Get property name and type using lambda expression
  15. @Html.Action in Asp.Net Core
  16. Add two Lists of different length in C#
  17. Append a Lists Contents to another List C#
  18. Number of occurrences of a character in a string [duplicate]
  19. Running a method in BackGroundWorker and Showing ProgressBar
  20. What are the costs and possible side effects of calling BuildServiceProvider() in ConfigureServices()
  21. Load a .DLL file and access methods from class within?
  22. How can I get Visual Studio 2008 Windows Forms designer to render a Form that implements an abstract base class?
  23. Is this thread.abort() normal and safe?
  24. How to print using XDocument
  25. Find out battery charge capacity in percentage using C# or .NET
  26. Most Useful Attributes [closed]
  27. Regular expression where part of string must be number between 0-100
  28. Doesn’t C# Extension Methods allow passing parameters by reference?
  29. Get a list of all tree nodes (in all levels) in TreeView Controls
  30. Using Include in Entity Framework 4 with lambda expressions

Leave a Comment