C#

<br />
private void txtEnterPassword_Leave(object sender, System.EventArgs e)<br />
		{<br />
			string queryValidatePwd = "SELECT Username, Password FROM AdminUsers WHERE Username = '" + lblLoginName.Text + "' AND Password = '" + txtEnterPassword.Text + "' ";<br />
<br />
			try<br />
			{<br />
				OleDbCommand cmdValidatePwd = cnnChangePassword.CreateCommand();<br />
				cmdValidatePwd.CommandType = CommandType.Text;<br />
				cmdValidatePwd.CommandText = queryValidatePwd;<br />
<br />
				OleDbDataAdapter daValidatePwd = new OleDbDataAdapter(cmdValidatePwd);<br />
				DataTable dtValidatePwd = new DataTable("AdminUsers");<br />
				<br />
				int count = daValidatePwd.Fill(dtValidatePwd);<br />
				if ( daValidatePwd.Fill(dtValidatePwd) == 1 ) //Password is correct<br />
				{<br />
					txtEnterNewPassword.Visible = true;<br />
					txtEnterNewPassword.Focus(); //Get focus of next text box.<br />
				}<br />
				else<br />
				{<br />
					MessageBox.Show("Password is incorrect for this username - please try again","Incorrect Password",MessageBoxButtons.OK,MessageBoxIcon.Warning);<br />
					txtEnterPassword.Clear();<br />
					txtEnterPassword.Focus();<br />
				}<br />
				dtValidatePwd.Dispose();<br />
				daValidatePwd.Dispose();		<br />
			}<br />
			catch ( OleDbException ex )<br />
			{<br />
				MessageBox.Show(ex.Message);<br />
			}<br />
			catch ( Exception ex )<br />
			{<br />
				MessageBox.Show(ex.Message);<br />
			}<br />
		}<br />

<br />
private void btnCancel_Click(object sender, System.EventArgs e)<br />
{<br />
	this.Dispose();<br />
}<br />