C # BULK Insert Data method

Bulk Insert Data method

void Inserttwo (list<coursearrangeinfo> dtF)
{
Stopwatch watch = new Stopwatch ();
Watch. Start ();
DataTable dt = new DataTable ();//temporary table for storing data
To construct a column for a table
Dt. Columns.Add ("Shoppingcartid");
Dt. Columns.Add ("produce_id");
Dt. Columns.Add ("number");
Dt. Columns.Add ("customer_id");
Dt. Columns.Add ("Createtime");
foreach (var item in DtF)
{
DataRow rows = dt. NewRow ();
rows["Shoppingcartid"] = System.Guid.NewGuid (). ToString ();
rows["produce_id"] = Item. produce_id;
rows["number"] = Item. number;
rows["customer_id"] = Item. customer_id;
rows["createtime"] = DateTime.Now;
Dt. Rows.Add (rows);
}
Key Code handling methods
var ss = configurationmanager.connectionstrings["Default"]. ConnectionString;
String connstr = cencrypt.decrystring (ss);//Connection string
using (SqlBulkCopy SqlBulkCopy = new SqlBulkCopy (CONNSTR))
{
Sqlbulkcopy.destinationtablename = "ShoppingCart";//define the name of the corresponding table to be stored in the database
SQLBULKCOPY.COLUMNMAPPINGS.ADD ("Shoppingcartid", "Shoppingcartid");
SQLBULKCOPY.COLUMNMAPPINGS.ADD ("produce_id", "produce_id");
SQLBULKCOPY.COLUMNMAPPINGS.ADD ("number", "number");
SQLBULKCOPY.COLUMNMAPPINGS.ADD ("customer_id", "customer_id");
SQLBULKCOPY.COLUMNMAPPINGS.ADD ("Createtime", "createtime");
Sqlbulkcopy.writetoserver (DT);
}
Watch. Stop ();
}

C # BULK Insert Data method