J'ai un probleme pour recuperer et tester la valeur envoyer par la requete sql select.
string Conn = "SERVER=localhost;" +
"DATABASE=ftpbd;" +
"UID=root;";
// try
{
MySqlConnection connection = new MySqlConnection(Conn);
MySqlCommand commandselect = connection.CreateCommand();
MySqlDataReader Readerselect;
//utilisatuer
commandselect.CommandText = "select LoginU, PasswordU from utilisateur";
connection.Open();
Readerselect = commandselect.ExecuteReader();
string login = LoginCon.Text;
string password = PasswordCon.Text;
//MessageBox.Show(login.ToString());
if (Readerselect["LoginU"] == login && Readerselect["PasswordU"] == password)
{
MessageBox.Show("heyyy connexion reussi");
}
else
{
MessageBox.Show("connexion echoué");
}
connection.Close();
}