VB.NET sqlbulkcopy 批量导入

最新推荐文章于 2023-07-21 16:31:19 发布

weixin_30559481

最新推荐文章于 2023-07-21 16:31:19 发布

阅读量748

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/gaoshoubuduo/archive/2009/12/29/1634703.html

本文介绍了一种使用VB.NET实现的数据批量导入方法，通过SqlBulkCopy组件将DataSet中的数据快速复制到SQL Server数据库中。该方法提高了数据迁移效率，并在出现错误时能够回滚事务确保数据一致性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Public Shared Function BulkCopy(ByVal ds As Object, ByVal DestinationTableName As String) As Boolean
        Dim rv As Boolean = False
        Dim myTrans As SqlTransaction = newTran()

        Dim bCopy As New SqlBulkCopy(myTrans.Connection, SqlBulkCopyOptions.CheckConstraints, myTrans)
        'bCopy.ColumnMappings("","")
        Try
            bCopy.WriteToServer(ds)
            myTrans.Commit()
            rv = True
        Catch ex As Exception
            myTrans.Rollback()
            MsgBox(ex.Message, MsgBoxStyle.Critical, "Error")
        Finally
            bCopy.Close()
            myTrans.Dispose()
        End Try
        Return rv
    End Function

转载于:https://www.cnblogs.com/gaoshoubuduo/archive/2009/12/29/1634703.html