public MySqlDataReader LecturetoutCategories()
{
try
{
string bddServeur = ConfigurationManager.AppSettings["serveur"];
string sBddPort = ConfigurationManager.AppSettings["port"];
int bddPort = Convert.ToInt16(sBddPort);
string bddBase = ConfigurationManager.AppSettings["base"];
string bddIdent = ConfigurationManager.AppSettings["identificateur"];
string bddMdp = ConfigurationManager.AppSettings["mdp"];
Connex = new Dbconnect(bddServeur, bddPort, bddBase, bddIdent, bddMdp);
if (Connex.OuvrirConnexion())
{
string requete = "SELECT * FROM categorie";
reader = Connex.RequeteSql(requete);
return(reader);
}
}
catch
{
return(reader);
}
Connex.FermerConnexion();
return(reader);
}
public MySqlDataReader LectureunInscrit(Int32 NumTranspondeur)
{
try
{
string bddServeur = ConfigurationManager.AppSettings["serveur"];
string sBddPort = ConfigurationManager.AppSettings["port"];
int bddPort = Convert.ToInt16(sBddPort);
string bddBase = ConfigurationManager.AppSettings["base"];
string bddIdent = ConfigurationManager.AppSettings["identificateur"];
string bddMdp = ConfigurationManager.AppSettings["mdp"];
Connex = new Dbconnect(bddServeur, bddPort, bddBase, bddIdent, bddMdp);
if (Connex.OuvrirConnexion())
{
string requete = "SELECT * FROM inscription WHERE transpondeur_IdTranspondeur = " + NumTranspondeur;
reader = Connex.RequeteSql(requete);
return(reader);
}
else
{
return(reader);
}
}
catch
{
Connex.FermerConnexion();
return(reader);
}
}