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'
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 Question | Next 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? |