private void _FilterAndInsert(DataSet sourceSet)
{
DataRow[] rows = sourceSet.Tables[0].Select("filter clauses here...");
DataTable tempTable = sourceSet.Tables[0].Clone();
foreach (DataRow row in rows)
{
tempTable.Rows.Add(row.ItemArray);
}
tempTable.AcceptChanges();
DataSet resultSet = new DataSet();
resultSet.Tables.Add(tempTable);
for (int index = 1; index < sourceSet.Tables.Count; index++)
{
DataTable tableToAdd = sourceSet.Tables[index].Copy();
sourceSet.Tables.RemoveAt(index);
resultSet.Tables.Add(tableToAdd);
}
sourceSet = resultSet.Copy();
}