Public voidSetuserreportresult (int[] ReportID,BOOLIsreceive,stringresult) { if(ReportID = =NULL) Throw NewArgumentNullException ("ReportID"); Result= result. Left ( the); stringsql ="Update Msg_user_receive_report Set isreceive="+ Convert.ToInt32 (isreceive) +","; if(!isreceive) SQL+="ukey= ' 0 ',"; varResultparam ="NULL"; if(Result! =NULL) Resultparam="'"+ result. Replace ("'",""'") +"'"; SQL+="result="+ Resultparam +", retrycount=retrycount+1,userreceivetime=sysdate where Id=:reportid"; Stopwatch Watch; using(varConnection = This. CreateConnection ()) {using(varCommand =connection. CreateCommand ()) {varSize =reportid.length; Command.commandtext=SQL; Command. Arraybindcount=size; Command. Parameters.Add (NewOracleParameter ("ReportID", oracledbtype.int32) {Value =ReportID}); Connection. Open (); Watch=stopwatch.startnew (); varc =command. ExecuteNonQuery (); Watch. Stop (); } connection. Close (); } trace.traceinformation ("data.setuserreportresult,watch="+Watch. Elapsedmilliseconds); }
Oracle BULK INSERT application in C #