今天忙了一天,就解决了一个在ASP.NET中批量插入oracle数据库,我之前一直做java,接触ASP.NET时间不久,可碰到了这样一个棘手的问题,最终还是在我的一味不放弃下,给攻下来了,分享给大家。呵呵!代码如下:
//注意insert语句构造有讲究,values后面的参数必须前面用“:”而非"@",这是oracleSQL与SqlServerSQL的很大区别,
//当然java就没这么麻烦了
string sqlStr = "Insert Into xt_operationlog(operationtime,operationcode,"
+ " objecttype,objectid,describe,employeeid,employeename,companyid,companyname,"
+ " subsystemid,subsystemname,transyyyymm,transsn) "
+ " Values(:appearTime,:operationType,:objectType,:objectID,:describe,:employeeID,:employeeName,"
+" :companyID,:companyName,:subSystemID,:subSystemName,:yearMonth,:currentTimes)";
//在数据量非常大的情况下,可象征性的选择几条记录作为DataSet集合,这样既省时间,有符合要求
string querySqlStr = "select xo.operationtime,xo.opera