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;


        }

　　

转载于:https://www.cnblogs.com/heisehenbai/p/6844155.html