110,533
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// DataTable批量写入到Oracle
/// </summary>
/// <param name="dataTable">待写入DataTable</param>
/// <returns>true:写入成功;false:写入失败</returns>
public static bool OracleBulkCopy(DataTable dataTable)
{
using (Oracle.DataAccess.Client.OracleConnection oracleConnection = new OracleConnection(BusinessConnString))
{
oracleConnection.Open();
Oracle.DataAccess.Client.OracleBulkCopy oracleBulkCopy = new Oracle.DataAccess.Client.OracleBulkCopy(oracleConnection);
oracleBulkCopy.DestinationTableName = dataTable.TableName;
try
{
oracleBulkCopy.WriteToServer(dataTable);
return true;
}
catch
{
return false;
}
}
}