![]() |
#2
DanYang_dan2011-12-10 16:44
|

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[]{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();
}
new OracleParameter(":pd",xinpassword),
new OracleParameter(":nbxh",nbxh)
};
这个的时候他就提示我ORA-01008: 并非所有变量都已关联 的错误. 找了一早上没找到问题.求高手指点下