转自:
摘要:
下文讲述使用c#代码快速将dataTable导入至mssql数据库的方法
实现思路:
需要将datatable调整为同目标表,表结构一致,然后采用
SqlBulkCopy 中快速writeToServer方法,可以快速将datatable复制至目标表中,
具体代码如下所示:
#region DatatTable快速写入 ///tb 待导入表 ///tbName mssql数据库中目标表表名 public string dataTableInsert(DataTable tb, string tbName) { string str = "0"; try { DbHelper d = new DbHelper(); SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(d.Conn.ConnectionString.ToString(), SqlBulkCopyOptions.UseInternalTransaction); sqlbulkcopy.DestinationTableName = tbName; sqlbulkcopy.WriteToServer(tb); str = "1"; d.Dispose(); d.Close(); } catch (Exception e) { str = e.Message.ToString(); } return str; } #endregion
如对本文有疑问, 点击进行留言回复!!
SQLSERVER中RANK OVER(PARTITION BY)的用法
Kaspersky Endpoint Security 10 for Windows version 10.2.6.3733 is no longer supported
网友评论