mysql check if password is correct c#
snippet in sql

mysql check if password is correct c#

user9735

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 ;
}