Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- maRequeteRechercheId = "SELECT fldIdentifiant FROM tbleleves WHERE fldIdentifiant = @Id";
- maCommandeRechercheId = new MySqlCommand(maRequeteRechercheId, maConnexion);
- maCommandeRechercheId.Parameters.Add(new MySqlParameter("@Id", MySqlDbType.String, 11));
- maRequeteSolde = "SELECT fldSolde FROM tbleleves WHERE fldIdentifiant = @Id";
- maCommandeSolde = new MySqlCommand(maRequeteSolde, maConnexion);
- maCommandeSolde.Parameters.Add(new MySqlParameter("@Id", MySqlDbType.String, 11));
- try { maCommandeRechercheId.Parameters["@Id"].Value = Convert.ToInt32(textBoxResultat.Text); }
- catch { labelErreurCode.Text = "Code barre ou QR code invalide"; }
- try { maCommandeSolde.Parameters["@Id"].Value = Convert.ToInt32(textBoxResultat.Text); }
- catch { labelErreurCode.Text = "Code barre ou QR code invalide"; }
- try
- {
- maCommandeRechercheId.Connection.Open();
- if (maCommandeRechercheId.ExecuteScalar() == null)
- {
- textBoxEleve.Text = "Elève non trouvé";
- maCommandeRechercheId.Connection.Close();
- return;
- }
- else
- {
- textBoxEleve.Text = "Elève trouvé";
- }
- maCommandeRechercheId.Connection.Close();
- try
- {
- maCommandeSolde.Connection.Open();
- maCommandeSolde.ExecuteNonQuery();
- iSoldeRestant = Convert.ToInt32(maCommandeSolde.ExecuteScalar());
- // Après ça continu mais c'est sans rapport avec mon problème
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement