how to check whether the given password is in database or not

private bool IsValidUser(string userName, string passWord)

{
bool loginSuccessful = false;
 string sql = "SELECT* FROM  Login WHERE Username=@UserName AND [Password]=@Password'";

SqlCommand sqlCommand= new SqlCommand(sql, con);
sqlCommand.Parameters.Add(new SqlParameter("Name", userName));
sqlCommand.Parameters.Add(new SqlParameter("[Password]", passWord));
SqlDataReader rdr = mySQL.ExecuteReader();

if (rdr.HasrRows()) 
   loginSuccessful = true;

return loginSuccessful ;
}

private void loginbtn_Click(object sender, EventArgs e)
 {
    if( IsValidUser(nametxtbx.Text.Trim(),passtxtbx.Text.Trim()))
    {
       //Redirect to .....
    }
    else 
    {
        // say Invalid Username or Password , please try again.
        nametxtbx.Text = "";
        passtxtbx.Text = "";
        nametxtbx.Focus();
    }
           
 }

BtnLogin_Click()
{

//Get the username and password from the text boxes


//call a function which connects to database procedure and store the return value in boolean variable

//if the return value is true
then open next page
//else
display custom error

}

Storeprocedure(uname varchar,pwd varchar)
{
check whether the record exists for that uname and pwd.
(something like select count(*) into intcount from users where upper(username)=uname and password=pwd)
if intcount>0 return true.
else return false.
}

cmd = New OleDbCommand("select empcode,password from tablename where empcode = '" + TextBox1.Text + "'AND password = '" + TextBox2.Text + "'", con)
                dr = cmd.ExecuteReader
                Try
                    If dr.HasRows Then
                        dr.Read()
                        If TextBox1.Text = dr.Item("empcode").ToString And TextBox2.Text = dr.Item("password").ToString Then
                          .........
                          .........
                        Else
                            MsgBox("USERNAME AND PASSWORD ARE CASE SENSITIVE. ")
                        End If
                    End If
                    dr.Close()