Oracle参数赋值

参数必须顺序赋值，否则会有问题。如下代码，param[0]赋account，1赋password会更新不成功。反之则没有问题。

 

           OracleParameter[] param =  new OracleParameter[ 2];


            OracleParameter p2 =  new OracleParameter( " password ", OracleDbType.Varchar2,  50);
            p2.Direction = ParameterDirection.Input;
            p2.Value = password;
            param[ 0] = p2;

            OracleParameter p1 =  new OracleParameter( " account ", OracleDbType.Varchar2,  50);
            p1.Direction = ParameterDirection.Input;
            p1.Value = account;
            param[ 1] = p1;

             string sql =  " update as_userInfo set pws= :password where account = :account ";
             int i = Platform.Data.OracleHelper.ExecuteNonQuery(Platform.Configuration.ConfigHelper.BusinessConnString,CommandType.Text, sql, param);

转载于:https://www.cnblogs.com/zyizyizyi/archive/2012/11/26/2788655.html