SqlBulkCopy c#

最新推荐文章于 2023-12-05 13:19:10 发布

xiaocui2018

最新推荐文章于 2023-12-05 13:19:10 发布

阅读量176

点赞数

本文链接：https://blog.csdn.net/xiaocui2018/article/details/118001880

版权

SqlBulkCopy c#

DataTable dt_test= new DataTable();
SqlConnection MyConn = new SqlConnection(ModuleUser.ConnectionString);
MyConn.Open();
SqlBulkCopy SbCopy = new SqlBulkCopy(MyConn);
try
{
SbCopy.DestinationTableName = “test”;
SbCopy.WriteToServer(dt_test);

            }
            catch (Exception err)
            {
            }
            finally
            {
                MyConn.Close();
                MyConn.Dispose();
                mydt.Dispose();
            }