DataTable 批量插入

最新推荐文章于 2021-10-17 10:36:52 发布

qingtiancx

最新推荐文章于 2021-10-17 10:36:52 发布

阅读量282

点赞数

分类专栏：个人笔记文章标签： DataTable

本文链接：https://blog.csdn.net/qingtiancx/article/details/50697899

版权

个人笔记专栏收录该内容

0 篇文章 0 订阅

订阅专栏

更新字典时使用DataTable 批量插入，做一下记录

public string UpdatePlaces(DataTable dt)
{
<span style="white-space:pre">	</span>try
<span style="white-space:pre">	</span>{
<span style="white-space:pre">		</span>using (SqlConnection conn = new SqlConnection(SqlHelper.strCon))
<span style="white-space:pre">		</span>{
<span style="white-space:pre">			</span>conn.Open();
<span style="white-space:pre">			</span>SqlTransaction trans = conn.BeginTransaction();
<span style="white-space:pre">			</span>try
<span style="white-space:pre">			</span>{
<span style="white-space:pre">				</span>string clearSql = "truncate table   [jkkc].[dbo].[tj_zd_place]";
<span style="white-space:pre">				</span>SqlHelper.ExecuteNonQuery(trans, CommandType.Text, clearSql);
<span style="white-space:pre">				</span>using (SqlBulkCopy copy = new SqlBulkCopy(conn, SqlBulkCopyOptions.KeepIdentity | SqlBulkCopyOptions.KeepNulls, trans))
<span style="white-space:pre">				</span>{
<span style="white-space:pre">					</span>copy.BatchSize = dt.Rows.Count;
<span style="white-space:pre">					</span>copy.DestinationTableName = "tj_zd_place";
<span style="white-space:pre">					</span>copy.WriteToServer(dt);
<span style="white-space:pre">				</span>}
<span style="white-space:pre">				</span>trans.Commit();
<span style="white-space:pre">				</span>return "";
<span style="white-space:pre">			</span>}
<span style="white-space:pre">			</span>catch (Exception ex)
<span style="white-space:pre">			</span>{
<span style="white-space:pre">				</span>trans.Rollback();
<span style="white-space:pre">				</span>return ex.Message;
<span style="white-space:pre">			</span>}
<span style="white-space:pre">		</span>}
<span style="white-space:pre">	</span>}
<span style="white-space:pre">	</span>catch (Exception ex)
<span style="white-space:pre">	</span>{
<span style="white-space:pre">		</span>return ex.Message;
<span style="white-space:pre">	</span>}
}