Private Sub CboBoxPays_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CboBoxPays.SelectedIndexChanged ' 'Ici tu récupere le code du pays. Dim CodePays As String = CboBoxPays.SelectedValue.ToString ' End Sub
'CREATION DE LA REQUETTE Dim maRequete As String maRequete = "SELECT pay_nom FROM pays WHERE pay_code '" & codePays & "'" 'LA COMMANDE Dim maCommande4 As New OleDbCommand(maRequete, Globale.connexion) Dim monDatareader As OleDbDataReader = maCommande4.ExecuteReader() With CboBoxPays .ValueMember = "pay_code" .DisplayMember = "pay_nom" .DataSource = monDatareader End With
Private Sub CboBoxPays_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CboBoxPays.SelectedIndexChanged ' 'Ici tu récupere le code du pays. Dim CodePays As String = CboBoxPays.SelectedValue.ToString ' End Sub
Dim maRequete As String "SELECT pay_nom FROM pays WHERE pay_code '" & codePays & "'"
Dim maRequete As String = "SELECT pay_nom FROM pays"
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim maRequete As String = "SELECT pay_nom, pay_code FROM pays"
'CREATION DE LA REQUETTE Dim SQLAjouterART As String SQLAjouterART = "INSERT INTO artiste (art_nom, art_prenom,art_nationalite,art_biographie, art_photo, pay_code) values('" & TxtNom.Text & "','" & TxtPrenom.Text & "','" & TxtNationalite.Text & "','" & RTxtBio.Text & "', '" & PBoxOeuvre1.ImageLocation & "'," &....& ")" 'LA COMMANDE Dim maCommande As OleDbCommand maCommande = New OleDbCommand() maCommande.Connection = Globale.connexion maCommande.CommandType = CommandType.Text maCommande.CommandText = SQLAjouterART 'EXECUTION maCommande.ExecuteNonQuery()
La hâte engendre en tout l'erreur, et de l'erreur sort bien souvent le désastre