批量上传超过1个Lac数据.... [英] Bulk Upload More than 1 Lac Data At a Time....

问题描述

嗨......



我想一次批量上传超过1个Lac数据....



谢谢





Anil Banjare

解决方案

< blockquote>

 使用（SqlBulkCopy bulkCopy = 
  new  SqlBulkCopy（ destinationConnection.ConnectionString））
 {
 bulkCopy.BatchSize =  500 ; 
 bulkCopy.NotifyAfter =  1000 ; 
 bulkCopy.SqlRowsCopied + = 
  new  SqlRowsCopiedEventHandler（bulkCopy_SqlRowsCopied）; 
 bulkCopy.DestinationTableName =   Dest_table; 
 bulkCopy.WriteToServer（reader）; 
} 
} 

问候，

Praveen Nelge

Hi....

I want to Bulk upload More Than 1 Lac Data at a time....

Thank You


Anil Banjare

解决方案

using (SqlBulkCopy bulkCopy =
        new SqlBulkCopy(destinationConnection.ConnectionString))
        {
            bulkCopy.BatchSize = 500;
            bulkCopy.NotifyAfter = 1000;
            bulkCopy.SqlRowsCopied +=
                new SqlRowsCopiedEventHandler(bulkCopy_SqlRowsCopied);
            bulkCopy.DestinationTableName = "Dest_table";
            bulkCopy.WriteToServer(reader);
        }
    }

Regards,
Praveen Nelge

这篇关于批量上传超过1个Lac数据....的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！