
急用:请好心人帮帮忙,谢谢!怎样在ASP.NET里写修改密码的代码?
其中主要包含四个Lable控件,用户名,原密码,新密码,确认密码,)确认修改按钮,如果修改成功显示密码修改成功…...
其中主要包含四个Lable控件,用户名,原密码,新密码,确认密码,)确认修改按钮,如果修改成功显示密码修改成功…
展开
2个回答
展开全部
新密码和确认密码用比较验证控件验证,用户名和原密码文本框分别定义为:txtuserName,txtuserID
string name=txtuserName.text;
string pwd=txtuserID.text;
string newpwd=txtnewUserID.text;
SqlConnection con = new SqlConnection("server=.;database=users;uid=sa;pwd=123");
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select count(*) from users where userName='"+name+"'and userID='"pwd+"'";
cmd.Connection=con;
int count=Convert.ToInt32(cmd.ExecuteScalar());
if(count>0)
{ cmd.CommandText="alter users set userID='"+newpwd+"'where userName='"+name+"'and userID='"pwd+"'";
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('修改成功!')</script>");}
else{Response.Write("<script>alert('用户名密码不正确)</script>");}
string name=txtuserName.text;
string pwd=txtuserID.text;
string newpwd=txtnewUserID.text;
SqlConnection con = new SqlConnection("server=.;database=users;uid=sa;pwd=123");
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select count(*) from users where userName='"+name+"'and userID='"pwd+"'";
cmd.Connection=con;
int count=Convert.ToInt32(cmd.ExecuteScalar());
if(count>0)
{ cmd.CommandText="alter users set userID='"+newpwd+"'where userName='"+name+"'and userID='"pwd+"'";
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('修改成功!')</script>");}
else{Response.Write("<script>alert('用户名密码不正确)</script>");}
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询