1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| using (OleDbCommand COMMANDE = new OleDbCommand())
{
//Association de la commande avec la connection
COMMANDE.Connection = CONNEXION_BASE;
COMMANDE.CommandText = "SELECT idAdherent, NomAd, DateNAd, dateInscriptionAd,TelAd, EmailAd FROM Adherent WHERE idAdherent=@idt OR NomAd LIKE '%@nomt%' OR DateNAd like '%@dn%' OR dateInscriptionAd LIKE '%di%' OR TelAd LIKE '%@telt%' OR EmailAd LIKE '%@emailt%'";
int id = Convert.ToInt32(textBox1.Text);
COMMANDE.Parameters.Add("idt", id);
COMMANDE.Parameters.Add("nomt", textBox1.Text);
COMMANDE.Parameters.Add("dn",Convert.ToDateTime( textBox1.Text).ToShortDateString());
COMMANDE.Parameters.Add("di", Convert.ToDateTime(textBox1.Text).ToShortDateString());
COMMANDE.Parameters.Add("telt", textBox1.Text);
COMMANDE.Parameters.Add("emailt", textBox1.Text);
// Execution de la requette et lecture du résultat en mode connecté
OleDbDataReader reader4 = COMMANDE.ExecuteReader();
} |
Partager