没有通过ASP在数据库上重置密码.网络应用程序

我正试图通过ASP将密码重置为数据库上的员工编号。网络应用程序。麻烦的是，它实际上并没有重置数据库上的密码，即使我得到一个确认消息，密码已被重置。

这是我当前的代码

SqlConnection sqlcon = new SqlConnection();
SqlCommand sqlCmd = new SqlCommand();
string empNo = "";
empNo = txtEmpNo.Text;
empReset = txtEmpNo.Text;
// sql statement to check if employee number exists in DB
SqlCommand check_User_Name = new SqlCommand("SELECT COUNT(*) FROM tbl_Login WHERE (Emp_ID = @user)", sqlcon);
check_User_Name.Parameters.AddWithValue("@user", empNo);
int UserExist = (int)check_User_Name.ExecuteScalar();
if (UserExist > 0)
{
    //EmpNo exists
    sqlCmd = new SqlCommand("update tbl_Login set Emp_Pass=@Pass where Emp_ID=@EmpID", sqlcon);
    sqlCmd.Parameters.AddWithValue("@EmpID", empNo);
    sqlCmd.Parameters.AddWithValue("@Pass", "1234");
    lblExists.Text = "Password reset!";
}// end if
else
{
    //EmpNo doesnt exist
    lblExists.Text = "Employee doesnt exists";
}//end else

if (UserExist > 0)
{
    //EmpNo exists
    sqlCmd = new SqlCommand("update tbl_Login set Emp_Pass=@Pass where Emp_ID=@EmpID", sqlcon);
    sqlCmd.Parameters.AddWithValue("@EmpID", empNo);
    sqlCmd.Parameters.AddWithValue("@Pass", "1234");
    sqlCmd.ExecuteNonQuery(); // <- execute update
    lblExists.Text = "Password reset!";
}// e

sqlCmd.ExecuteNonQuery();