C# SqlBulkCopy

        public void Insert_Table(System.Data.DataTable dataTable)
        {
            try
            {
                using (var bulk = new SqlBulkCopy(conn))
                {
                    bulk.DestinationTableName = "TableName";//表名称
                    bulk.BatchSize = 1000;
                    //循-环所有列为abulk添加映射
                    bulk.ColumnMappings.Add("字段ID", "columnID");
                    bulk.ColumnMappings.Add("字段内容", "columnValue");
                    bulk.ColumnMappings.Add("表格行", "record_id");
                    bulk.WriteToServer(dataTable);
                }
            }
            catch (Exception e)
            {
                throw;
            }
        }