/// <summary>
/// SqlBulkCopy批量插入数据库
/// </summary>
/// <param name="dtData">数据源</param>
/// <param name="targetTableName">目标数据表</param>
/// <returns></returns>
public bool SqlExcuteBulkData(DataTable dtData, string targetTableName)
{
bool result = false;
using (OracleConnection conn = new OracleConnection(DBHelper.connectionString))
{
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(DBHelper.connectionString, SqlBulkCopyOptions.Default))
{
if (dtData != null && dtData.Rows.Count > 0)
{
bulkCopy.DestinationTableName = targetTableName;
for (int i = 0; i < dtData.Columns.Count; i++)
{
string col = dtData.Columns[i].ColumnName;
bulkCopy.ColumnMappings.Add(col, col);
}
conn.Open();
bulkCopy.WriteToServer(dtData);
result = true;
}
}
}
return result;
}