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

Submitted by: Administrator
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'
Submitted by: Administrator

Read Online ADO.NET Job Interview Questions And Answers