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

Top 5 Contributors of the Month
Sharon Maxwell

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))

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


Further Readings:


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