.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Code Snippets >> ADO.NET >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

Bulk Copy Operation

Posted By:Nikhil Kumar       Posted Date: February 27, 2010    Points: 10    Category: ADO.NET    URL: http://www.dotnetspark.com  

This code shows you how to do bulk copy operation using C#.
 

string connectionString = "";
using (SqlConnection sc = new SqlConnection(connectionString))
{ 
    sc.Open();

    SqlCommand commandSourceData = new SqlCommand("SELECT * FROM StoresBackup;", sc);
    SqlDataReader reader =  commandSourceData.ExecuteReader();
    using (SqlConnection dc = new  SqlConnection(connectionString))
    { 
        dc.Open();
        using (SqlBulkCopy bulkCopy = new SqlBulkCopy(dc))
        {
             bulkCopy.DestinationTableName = "Stores";
             bulkCopy.WriteToServer(reader);
        }
    }
}


     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend