How To Copy The Contents From One Table To Another Table And How To Delete The Source Table In Ado.net?

How To Copy The Contents From One Table To Another Table And How To D

1.	How To Copy The Contents From One Table To Another Table And How To Delete The Source Table In Ado.net?
Answer» Answer : 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'