SqlBulkCopy 批量插入
ASP.NET批量插入的一种方式,直接上代码(方便以后查找):
public static int ExcuteAddMany(string cmdStr, string[] tempArray, params SqlParameter[] sqlParams) { DataTable table = new DataTable(); table.Columns.Add("Name"); table.Columns.Add("LayerNum"); for (int i=0; i<tempArray.Length;i++) { DataRow row = table.NewRow(); row["Name"] = tempArray[i].ToString(); row["LayerNum"] = 0; table.Rows.Add(row); } string connectionStr = "server=PC-201701130905\\B;uid=sa;pwd=s07j08b11;database=TripMaster"; using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connectionStr)) { bulkCopy.BatchSize = table.Rows.Count; bulkCopy.DestinationTableName = "SQLBulkCopyTest";//在插入的目标表 //DataTable列名与数据库列名的映射 bulkCopy.ColumnMappings.Add("LayerNum", "LayerNum"); bulkCopy.ColumnMappings.Add("Name", "Name"); bulkCopy.WriteToServer(table);//写入到数据库中 } return 1; }