bonjour,
vous pouvez m'aider a corrige cette requete dans ce code
Protected Sub Valider1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Valider1.Click
Dim requete As String = "insert into Arret_DAB values (" & GAB1.Text & "," & Ordre1.Text & ",'" & Panne1.Text & "','"
requete = String.Concat(requete, Date_Arret1.Text, "',", Temps_Arret1.Text, "',", Date_Reprise1.Text, "','", Temps_Reprise1.Text, ")")
Dim connex As New Data.OleDb.OleDbConnection
connex.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrateur\Mes documents\Visual Studio 2005\WebSites\suivi des DAB\DAB.mdb"
connex.Open()
Dim cmd As Data.OleDb.OleDbCommand = New Data.OleDb.OleDbCommand(requete, connex)
cmd.CommandText = requete
cmd.ExecuteNonQuery()
End Sub
tel que les types des champs sont:text, date, numérique
merci d'avance