ADO.NET Question:
Download Questions PDF

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

Answer:

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'

Download ADO.NET Interview Questions And Answers PDF

Previous QuestionNext Question
How to find the given query is optimised one or not?How to call the SQL commands asynchronously in ADO.NET version 2.0?