I have an array of DataTable objects all with the exact same schema.  I 
want to concatenate these into one DataTable. Here's what I tried....

// each DataTable in the array has the exact same schema.
// tableArray[] is an array of DataTable
DataTable wholeTable = new DataTable();
DataRow dr;
foreach ( DataTable dt in tableArray )
{
	for ( int y = 0; y < dt.Rows.Count; y++ )
	{
		dr = dt.Rows[y];
		wholeTable.Rows.Add( dr );
		// ERROR: the line above throws and exception claiming the 
		// data row cannot be added because it already belongs
		// to another table.
	}
}

Any suggestions?

look at the "ImportRow" method for the datatable.  This is what you 
need.

-----Original Message-----
From: David Garner [mailto:dgarner@g...]
Sent: Friday, May 17, 2002 5:17 PM
To: ADO.NET
Subject: [ado_dotnet] DataTable[] concatenated to DataTable


I have an array of DataTable objects all with the exact same schema.  I
want to concatenate these into one DataTable. Here's what I tried....

// each DataTable in the array has the exact same schema.
// tableArray[] is an array of DataTable
DataTable wholeTable =3D new DataTable();
DataRow dr;
foreach ( DataTable dt in tableArray )
{
	for ( int y =3D 0; y < dt.Rows.Count; y++ )
	{
		dr =3D dt.Rows[y];
		wholeTable.Rows.Add( dr );
		// ERROR: the line above throws and exception claiming the
		// data row cannot be added because it already belongs
		// to another table.
	}
}

Any suggestions?

You rock.  That worked perfectly.