1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Using Bdd As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & NomFichier & ";User Id=admin;Password=;")
Using Cmd As New OleDb.OleDbCommand("Insert into [Histo] (DateHeure,Millisecondes,NumEvent,NumEquip,Etat,Api) values (@DateHeure,@Millisecondes,@NumEvent,@NumEquip,@Etat,@Api)", Bdd)
Try
Cmd.Parameters.Add("@DateHeure", OleDb.OleDbType.Date).Value = D
Cmd.Parameters.Add("@Millisecondes", OleDb.OleDbType.Integer).Value = 0
Cmd.Parameters.Add("@NumEvent", OleDb.OleDbType.Integer).Value = -1
Cmd.Parameters.Add("@NumEquip", OleDb.OleDbType.Integer).Value = -1
Cmd.Parameters.Add("@Etat", OleDb.OleDbType.Integer).Value = -1
Cmd.Parameters.Add("@API", OleDb.OleDbType.Char).Value = Automate.Nom
Bdd.Open()
Cmd.ExecuteNonQuery()
Bdd.Close()
Catch ex As Exception
Call MsgBox("Erreur lors de l'accès au fichier TOTAL.MDB", MsgBoxStyle.Critical, "ERREUR")
Return False
End Try
End Using
End Using |
Partager