asp.net密码修改

来源:百度知道 编辑:UC知道 时间:2024/06/06 17:07:10
我写的代码:
string pPwd = this.OldPwd.Text;
string NewPwd=this.NewPwd.Text;
SqlConnection conn = DB.CreateConnection();
string str=("update Personal set pPwd= '" +NewPwd + "'where pPwd='" +pPwd +"'");
SqlCommand cmd = new SqlCommand(str, conn);
Response.Write("<script language='javascript'>alert('密码修改成功');window.location.href('main.aspx');</script>");
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
“旧密码输入错误”的信息怎么输出??代码??

逻辑都不对
string pPwd = this.OldPwd.Text;
string NewPwd=this.NewPwd.Text;
SqlConnection conn = DB.CreateConnection();
string str=("update Personal set pPwd= '" +NewPwd + "'where pPwd='" +pPwd +"'");
SqlCommand cmd = new SqlCommand(str, conn);
conn.Open();
int i=Convert.ToInt32(cmd.ExecuteNonQuery());
conn.Close();
if(i==1)
Response.Write("<script language='javascript'>alert('密码修改成功');window.location.href('main.aspx');</script>");
else
Response.Write("<script language='javascript'>alert('密码修改失败);script>");