注册 登录
编程论坛 ASP.NET技术论坛

更新数据时提示 ORA-01008: 并非所有变量都已关联 错误.请人指点错误在哪里

kgdipbyve 发布于 2011-12-09 13:29, 1028 次点击
程序代码:
  string xinpassword = FormsAuthentication.HashPasswordForStoringInConfigFile(xinpwd2, "MD5");
                string nbxh=Session["nbxh"].ToString();
                string UsrName=Session["UserName"].ToString();
                string sqlupdata = "update HYW_USRENAMEINFO set USERPWD=:pd  where NBXH=:nbxh";
              //  OracleCommand cmd = new OracleCommand(sqlupdata,conn);
              
//  OracleParameter oraclepare=new OracleParameter();
               
// cmd.Parameters.Add("pwd", OracleType.VarChar).Value = xinpassword;
               
// cmd.Parameters.Add("nbxh", OracleType.VarChar).Value = Session["nbxh"];
            
               
// conn.Open();
               
            
//int a = cmd.ExecuteNonQuery();
            
// if (a > 0) {

              
//   Response.Write("<script>alert('修改成功');location.href='frame.aspx'</script>");
               
//  Response.End();
                    
//}
                OracleCommand cmd = new OracleCommand(sqlupdata, conn);
                OracleParameter[] paremeterArr=new OracleParameter[]{
                  
                  
                    new OracleParameter("pd",xinpassword),
                    new OracleParameter("nbxh",nbxh)
                  
                };
              
                conn.Open();
               int a= cmd.ExecuteNonQuery();

 if (a > 0) {

                 Response.Write("<script>alert('修改成功');location.href='frame.aspx'</script>");
                 Response.End();
               }
注释的运行是对的。但是我用    OracleParameter[] paremeterArr=new OracleParameter[]{
                  
                    
                    new OracleParameter(":pd",xinpassword),
                    new OracleParameter(":nbxh",nbxh)
                  
                };
               
 这个的时候他就提示我ORA-01008: 并非所有变量都已关联 的错误.  找了一早上没找到问题.求高手指点下
1 回复
#2
DanYang_dan2011-12-10 16:44
sqlparameter和oracleParameter的用法应该差不多的吧。看着参数怪怪的
1