SqlBulkCopy批量插入数据库

最新推荐文章于 2023-09-12 11:41:23 发布

算盘

最新推荐文章于 2023-09-12 11:41:23 发布

阅读量172

点赞数

分类专栏： C#

本文链接：https://blog.csdn.net/codinglab/article/details/107786690

版权

C# 专栏收录该内容

83 篇文章 2 订阅

订阅专栏

        /// <summary>
        /// SqlBulkCopy批量插入数据库
        /// </summary>
        /// <param name="dtData">数据源</param>
        /// <param name="targetTableName">目标数据表</param>
        /// <returns></returns>
        public bool SqlExcuteBulkData(DataTable dtData, string targetTableName)
        {
            bool result = false;
            using (OracleConnection conn = new OracleConnection(DBHelper.connectionString))
            {
                using (SqlBulkCopy bulkCopy = new SqlBulkCopy(DBHelper.connectionString, SqlBulkCopyOptions.Default))
                {
                    if (dtData != null && dtData.Rows.Count > 0)
                    {
                        bulkCopy.DestinationTableName = targetTableName;
                        for (int i = 0; i < dtData.Columns.Count; i++)
                        {
                            string col = dtData.Columns[i].ColumnName;
                            bulkCopy.ColumnMappings.Add(col, col);
                        }
                        conn.Open();
                        bulkCopy.WriteToServer(dtData);
                        result = true;
                    }
                }
            }
            return result;
        }