How to copy the contents from one table to another table and how to delete the source table in ado.net?
it is possible
Datatable dt = ds.Tables.copy();
//now the structure and data are copied into ‘dt’
//now the source is removed from the ‘ds’