Bhavesh Vankar

Bhavesh Vankar

  • 755
  • 1.2k
  • 89.2k

change password

Jul 27 2022 6:23 AM

i have done below code for change user password but their is no result and not working kindly help me to resolve this query....

i want to change password when user try to change password then first current password should be verify from the table...

my code is below....where i made mistake kindly help me ....

SqlConnection con = new SqlConnection(sqlCon);
con.Open();
string sqlSelect = "SELECT * FROM LOGIN_MASTER WHERE PASSWORD='"+ txtoldPassword.Text +"'";
SqlCommand cmd = new SqlCommand(sqlSelect, con);
//SqlDataAdapter sda = new SqlDataAdapter(cmd);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.HasRows)
{
    //while (sdr.Read())
    //{
        if (sdr["PASSWORD"].ToString() == txtoldPassword.Text)
        {
            SqlConnection con2 = new SqlConnection(sqlCon);
            con2.Open();
            string updatePass = "UPDATE LOGIN_MASTER SET PASSWORD='" + txtconfPassword.Text + "' WHERE USERID='" + Session["uname"].ToString() + '";
            SqlCommand cmd2 = new SqlCommand(updatePass, con);
            SqlDataAdapter sda2 = new SqlDataAdapter(cmd2);
            cmd2.ExecuteNonQuery();
            lblmessage.Visible = true;
            lblmessage.Text = "Password change successfully...";
            con2.Close();
            Session.RemoveAll();
            Session.Abandon();
            Response.Redirect("~/Sign_In");
            Session.Clear();
        }
        else
        {
            lblmessage.Visible = true;
            lblmessage.Text = "Old Password Not Matched, Re-enter currect old password";
            txtoldPassword.Focus();
        }
        sdr.Close();
        con.Close();
    }
}

 


Answers (3)