Monday, February 6, 2012

Row already belongs to another table

November 1, 2009 by · Leave a Comment 

When copying a row from one datatable to another you might get the error "this row already belongs to another table". Typically you might write code like this: string sConnString = ConfigurationManager.ConnectionStrings["NorthwindConn"].ConnectionString; DataSet ds = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(sConnString,CommandType.Text, "select * from suppliers order by supplierid"); int nRowCount = 0; DataTable dt = ds.Tables[0];DataTable dt2 = dt.Clone(); dt2.Clear(); [...]