嗨,我很难更改密码 [英] Hi i am having difficulty in changing the password
问题描述
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="changepassword.aspx.cs" Inherits="changepassword" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Change Password</title>
</head>
<body bgcolor="#CCFFFF">
<center>
<h1><u>Online Shopping Cart</u></h1></center>
<form id="form1" runat="server">
<div>
<p align="center"><font size="5"><b>Change Password</b></font></p>
<asp:Panel style="position:absolute; top: 143px; left: 458px; height :182px; width: 340px; margin-top: 3px;" ID="Panel1"
runat="server" BackColor="Silver" BorderColor="#660033"
BorderStyle="Solid" HorizontalAlign="Center" ScrollBars="Vertical">
<table align="center" cellpadding="2" cellspacing="2" width="100%">
<tr>
<td style="padding-left:10px">
User ID</td>
<td>
<asp:TextBox ID="UserId" Runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td style="padding-left:10px">
Old Password</td>
<td>
<asp:TextBox ID="Pwd" Runat="server" TextMode="Password"></asp:TextBox>
</td>
</tr>
<tr>
<td style="padding-left:10px">
New Password</td>
<td>
<asp:TextBox ID="NPwd" Runat="server" CssClass="TblBorder" TextMode="Password"></asp:TextBox>
</td>
</tr>
<tr>
<td height="20" style="padding-left:10px">
Confirm Password </td>
<td>
<asp:TextBox ID="CPwd" Runat="server" CssClass="TblBorder" TextMode="Password"></asp:TextBox>
</td>
</tr>
<tr>
<td height="5">
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:Button ID="Submit" runat="server" OnClick="Submit_Click" />
<%--<asp:Button ID="Cancel" runat="server" OnClick="Cancel_Click" />
--%></td>
</tr>
</table>
</asp:Panel>
</div>
</form>
</body>
</html>
文件后面的代码
受保护的void Submit_Click(对象发送者,EventArgs e)
{
SqlConnection con =新的SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings ["sampleConnectionString2"].ToString();
con.Open();
SqlCommand cmd =新的SqlCommand("UPDATE Users SET Password =""+ NPwd.Text.Trim()+"其中UserName =""+ UserId.Text +""AND Password =""+ Pwd.Text + ");
cmd.ExecuteNonQuery();
con.Close();
Response.Write(< script language = Javascript> alert(``您的密码已更改,请使用新密码登录'')</script>");
Response.Redirect(〜/Default.aspx");
}
}
在执行nonquery
code behind file
protected void Submit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["sampleConnectionString2"].ToString();
con.Open();
SqlCommand cmd=new SqlCommand("UPDATE Users SET Password=''" +NPwd.Text.Trim()+ "'' where UserName = ''" +UserId.Text+ "'' AND Password=''" +Pwd.Text+ "''");
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script language=Javascript>alert(''Your Password Has Been Changed,Please Login With New Password'')</script>");
Response.Redirect("~/Default.aspx");
}
}
its showing error while updating password in execute nonquery
推荐答案
SqlCommand cmd=new SqlCommand("UPDATE Users SET Password='" +NPwd.Text.Trim()+ "' where UserName = '" +UserId.Text+ "' AND Password='" +Pwd.Text+ "'",con);
这篇关于嗨,我很难更改密码的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!