Big Data copy: SqlBulkCopy (from www.sysoft.net.cn)

When writing large data (more than 100000 rows of data) to the database, the normal way is time-consuming, but ADO provides a sqlbulkcopy class that can greatly increase the speed of data insertion.
using (SqlBulkCopy sqlbulkcopy=new SqlBulkCopy (constr)// Establish an object instance with the parameter as a database connection string
{
SqlBulkCopy. destinationtablename=tbname//Specify the worksheet to import data into the database
SqlBulkCopy. Columnmappings.add (Sourname,tbname)// Specify column mappings where the parameter sourcename is the column name in the source DataSet, Tbname represents the column name for the worksheet in the database
......
SqlBulkCopy. WriteToServer (SourceName)// writes the specified data source data (typically DataTable type data) to the database.

}

Big Data copy: SqlBulkCopy (from www.sysoft.net.cn)