title: ASP.NET Membership ChangePassword control - Need to check for previous password
body: <p>I have a new table that hold old passwords, I need to check if there is a match.</p>
  
  <p>If there is a match I need the ChangePassword contol to NOT change the password. I need to tell the user that this password was used and pic a new one.</p>
  
  <p>I can't seem to be able to interrupt the control from changing the password. 
  Maybe I am using the wrong event.</p>
  
  <p>Here is a piece of my code, or how I wish it would work.
  I appreciate all your help.</p>
  
  <pre><code>protected void ChangePassword1_ChangedPassword(object sender, EventArgs e)
      {
          MembershipUser user = Membership.GetUser();
          string usrName = "";
          if (user != null)
          {
              string connStr = ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString;
              SqlConnection mySqlConnection = new SqlConnection(connStr);
              SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
              mySqlCommand.CommandText = "Select UserName from OldPasswords where UserName = 'test'";
              mySqlConnection.Open();
              SqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(CommandBehavior.Default);
              while (mySqlDataReader.Read())
              {
                  usrName = mySqlDataReader["UserName"].ToString();
                  if (usrName == user.ToString())
                  {
  
                      Label1.Text = "Match";
                  }
                  else
                  {
                      Label1.Text = "NO Match!";
                  }
              }
  </code></pre>