DataTable 批量插入

来源：互联网发布：二手双拼域名编辑：程序博客网时间：2024/04/28 22:13
更新字典时使用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>}}
0 0