C# -- trying to add dataset row from one dataset to another -- ERROR: This row already belongs to another table.
Posted on 2006-06-21
I have a dataset with lets say ten rows. I am trying to loop through the dataset and find those that have the first column equal to 'ABC' and add those to another dataset. Refer to my code below. I receive the error 'This row already belongs to another table'. I need to create a separate dataset as I am needing to use the data somewhere else.
foreach(DataRow dr in dsAll.Tables.Rows)
if (dr.ToString() == "ABC")