文章标题

代码

 #region 批量插入数据 /*-----------------传入的datatable列要与数据表列完全一致包括列的顺序-----------------*/        /// <summary>        /// 批量插入数据        /// </summary>        /// <param name="tableName"> 传入要插入的数据表名</param>        /// <param name="dtWork">datatable类型</param>        /// <param name="gxTarget">数据源</param>        private void SqlBulkCopyByDatatable(string tableName, DataTable dtWork, DbHelper gxTarget)        {            string connectionString = gxTarget.connectionString;            using (SqlConnection conn = new SqlConnection(connectionString))            {                using (SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.UseInternalTransaction))                {                    try                    {                        sqlbulkcopy.DestinationTableName = tableName;                        sqlbulkcopy.WriteToServer(dtWork);                    }                    catch (Exception ex)                    {                        LogHelper.AddLog("写入数据表出现错误：" + ex.Message + ex.StackTrace);                    }                }            }        }        #endregion