SQL Server Bulk Copy in C# Application.

using (SqlConnection connection = new SqlConnection(ConString))
{
    using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
    {
        bulkCopy.DestinationTableName = "dbo.DestinationTable";
        try
        {
            connection.Open();
            // Write from the source to the destination.
            bulkCopy.WriteToServer(tblSourceTable);
            connection.Close();
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message.ToString()); return;
        }
    }
}
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s