ADO.NET Questions and Answers

How to copy the contents from one table to another table and how to delete the source table in ado.net?

it is possible

DataSet ds;

sqlAdap.Fill(ds);

Datatable dt = ds.Tables[0].copy();

//now the structure and data are copied into ‘dt’

ds.Tables.remove(ds.Table[0]);

//now the source is removed from the ‘ds’