In previous post we have learned how to create simple login form and create registration form in asp.net using sql database with c# language.
In this asp.net post, we will learn how to create a change password form for already registered user. For change password user first need to register with detail and get username and password. After register user has to login with his username and password. if username and password march then change password form loaded to user screen and user can change his password by verifying current password.
First create a sql table for store user registration detail. we have here created sql table “UserMst” like below:
Here is the sql script for UserMst table:
CREATETABLE[dbo].[UserMst]
([ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
[Name] [nvarchar](50) NULL,
[SurName] [nvarchar](50) NULL,
[City] [nvarchar](50) NULL,
[Email] [nvarchar](50) NULL,
[Password] [nvarchar](50) NULL,)
The html source code for change password form design.
<table align="center" class="style1" style="border: thin solid #008080">
<tr>
<td colspan="3"
style="border-bottom: thin solid #008080; font-weight: 700; text-align: center;">
Change Password Form</td>
</tr>
<tr>
<td class="style5">
</td>
<td class="style4">
</td>
<td>
</td>
</tr>
<tr>
<td class="style6">
Enter Current Password :
</td>
<td class="style4">
<asp:TextBox ID="txtcurrentpass" runat="server" Width="120px"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="txtcurrentpass" ErrorMessage="!!" ForeColor="Red"
SetFocusOnError="True"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="style6">
Enter New Password :</td>
<td class="style4">
<asp:TextBox ID="txtnewpass" runat="server" Width="120px"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ControlToValidate="txtnewpass" ErrorMessage="!!" ForeColor="Red"
SetFocusOnError="True"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="style6">
Confirm Password : </td>
<td class="style4">
<asp:TextBox ID="txtconfirmpass" runat="server" Width="120px"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
ControlToValidate="txtconfirmpass" ErrorMessage="!!" ForeColor="Red"
SetFocusOnError="True"></asp:RequiredFieldValidator>
<asp:CompareValidator ID="CompareValidator1" runat="server"
ControlToCompare="txtnewpass" ControlToValidate="txtconfirmpass"
ErrorMessage="password not same !!" ForeColor="Red"></asp:CompareValidator>
</td>
</tr>
<tr>
<td class="style5">
</td>
<td class="style4">
<asp:Button ID="btnchangepass" runat="server" Text="Change Password"
onclick="btnchangepass_Click" />
</td>
<td>
</td>
</tr>
<tr>
<td class="style5">
</td>
<td class="style2" colspan="2">
<asp:Label ID="lblmsg" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td colspan="3">
</td>
</tr>
</table>
The design asp.net form layout is:
Here, we first check the use current password, if matches then user can make new password or we can also say change password.
we user required field validator control for all three textboxes and user compare validator for compare new password and confirm password field in change password asp.net example.
The c# code for change password button.
protected void btnchangepass_Click(object sender, EventArgs e)
{
lblmsg.Text = "";
SqlConnection SQLConn = new SqlConnection("Data Source=.\\SQLExpress; Initial Catalog=Blog; Integrated Security=True");
SqlDataAdapter SQLAdapter = new SqlDataAdapter("select * from UserMst where password='"+txtcurrentpass.Text+"'", SQLConn);
DataTable DT = new DataTable();
SQLAdapter.Fill(DT);
if (DT.Rows.Count == 0)
{
lblmsg.Text = "Invalid current password";
lblmsg.ForeColor = System.Drawing.Color.Red;
}
else
{
SQLAdapter = new SqlDataAdapter("update usermst set password='" + txtnewpass.Text + "' where email='" + Session["uname"].ToString() + "'", SQLConn);
SQLAdapter.Fill(DT);
lblmsg.Text = "Password changed successfully";
lblmsg.ForeColor = System.Drawing.Color.Green;
}
}
In above change password asp.net example we use session[“uname”] in update sql query for change password. When user login in to system with his username and password at that time if credential match then store username or email in session[“uname”].
Thank you so much, your this code much help me
m read to many sites StackOverflow, snippets but your codes simple & easy for understand its work thank you 🙂
thank you so much. it works fine for me.
Thank you so much, your this code much help me
m read to many sites StackOverflow, snippets but your codes simple & easy for understand its work thank you ?
thank you..
easy code to changing password in Window form with c#