1 pièce(s) jointe(s)
Probleme de requete "modifier"
bonsoir a vous, s'il vous plait, j'aimerais coder mon bouton "MODIFIER", et quand je compile cela m'affiche cette erreur. sur image; et voici le code:
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| Private Sub btnmodif_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnmodi.Click
Dim c As OleDbConnection = New OleDbConnection
c.ConnectionString = chain
c.Open()
Dim requet As String = "UPDATE specialite SET n_qtier=[n_qtier] WHERE idqtier=[idqtier]"
Dim req As OleDbCommand = New OleDbCommand
req.Connection = c
req.CommandText = requet
Dim resp As Integer = req.ExecuteNonQuery()
If (resp <> 0) Then
MsgBox("Quartier modifié abvec success")
c.Close()
charge()
End If
End Sub |