One more technique is to perform bulk copy in a transaction. Using this technique one can perform multiple bulk copy operation along with other database operations i.e. update, delete etc and as one is using transaction it canbe easily commited or rolled back.

A Windows form was created using Visual Studio 2005 with a single button 'bulkcopy', as one clicks on this button data is copied and a message is shown to user

Features
Besides bulk copy, ADO.NET version 2.0 has plenty of new features, here we are listing some of them:
(a) Multiple Active Results Sets(MARS)-allows application to have multiple 'SqlDataReader' open on a connection where each instance of 'SqlDataReader' is started from a separate command.

To verify our results we went back to SQL Server Manager to check contents of 'Table_2' and found that valus of 'Table_1' were present

(b) Batch processing-another feature included to enhance application performance is batch processing in which updates to databse from 'Dataset' are done in batches.
(c) Data tracing-an interesting feature is built-in data tracing supported by .NET data providers.
All these features of ADO.NET version 2.0 make it a better and efficient tool for data access.