Editing User Account

ung txtConPass ko is ung Confirmation input textbox
ung txtNewPass ko is ung New Password input textbox
ung oldPass ko is ung Old Password existing
ung highlighted texts ko, dat is not working. That is my problem.
I need to check if the old password that he typed is existing. When it is existing, then update the db. But if not, do not update. The problem is, even if the password that he typed does not correspond to the user that he is editing, still the data is being updated. Please help me fix it. Maybe I have to use other codes. Tnx!




Private Sub OK_Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK_Button.Click
Me.DialogResult = System.Windows.Forms.DialogResult.OK
Dim oldPass As String = frmUsers.UsersDataGridView.SelectedRows(0).DataBoundItem(2).ToString
Dim check As Boolean = True


If Me.txtConPass.Text.Length = 0 Or Me.txtNewPass.Text.Length = 0 Then
check = False
ElseIf Not Me.txtConPass.Text.ToString.Equals(Me.txtNewPass.Text.ToString) Then
check = False
ElseIf Me.PasswordTextBox.Text.ToString.Equals(oldPass) Then
check = True
Else
End If


If check = True Then
Me.UsersTableAdapter.UpdateQueryBySearchID(Me.UsernameTextBox.Text, Me.txtNewPass.Text, Me.NameTextbox.Text, frmUsers.UsersDataGridView.SelectedRows(0).DataBoundItem(0).ToString)
Me.Close()
Me.txtConPass.Text = ""
Me.txtNewPass.Text = ""
MsgBox("Your account has been updated.", MsgBoxStyle.Information)
frmUsers.Close()
Else
MsgBox("Unable to update data.", MsgBoxStyle.Exclamation)
End If
End Sub