1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
Private Sub Miseajour()
Dim sqltxt As String = "Delete * from Consultations;"
Using cmd As OleDbCommand = New OleDbCommand(sqltxt, con)
Try
' on efface toute la table
con.Open()
cmd.ExecuteNonQuery()
' on remet les lignes unes à unes
For i As Integer = 0 To Grille.Rows.Count - 1
With Grille
Dim sqltxt1 As String = "Insert into Consultations Values('" & .Item(0, i).Value.ToString & "','" & .Item(1, i).Value.ToString & "','" & .Item(2, i).Value.ToString & "','" & .Item(3, i).Value.ToString & "','" & .Item(4, i).Value.ToString & "','" & .Item(5, i).Value.ToString & "','" & .Item(6, i).Value.ToString & "','" & .Item(7, i).Value.ToString & "','" & .Item(8, i).Value.ToString & "','" & .Item(9, i).Value.ToString & "','" & .Item(10, i).Value.ToString & "','" & .Item(11, i).Value.ToString & "','" & .Item(12, i).Value.ToString & "','" & .Item(13, i).Value.ToString & "','" & .Item(14, i).Value.ToString & "','" & .Item(15, i).Value.ToString & "','" & .Item(16, i).Value.ToString & "','" & .Item(17, i).Value.ToString & "','" & .Item(18, i).Value.ToString & "','" & .Item(19, i).Value.ToString & "','" & .Item(20, i).Value.ToString & "','" & .Item(21, i).Value.ToString & "','" & .Item(22, i).Value.ToString & "','" & .Item(23, i).Value.ToString & "','" & .Item(24, i).Value.ToString & "','" & .Item(25, i).Value.ToString & "','" & .Item(26, i).Value.ToString & "','" & .Item(27, i).Value.ToString & "','" & .Item(28, i).Value.ToString & "','" & .Item(29, i).Value.ToString & "','" & .Item(30, i).Value.ToString & "','" & .Item(31, i).Value.ToString & "','" & .Item(32, i).Value.ToString & "','" & .Item(33, i).Value.ToString & "','" & .Item(34, i).Value.ToString & "','" & .Item(35, i).Value.ToString & "','" & .Item(36, i).Value.ToString & "','" & .Item(37, i).Value.ToString & "');"
Using cmd1 As OleDbCommand = New OleDbCommand(sqltxt1, con)
cmd1.ExecuteNonQuery()
End Using
End With
Next
con.Close()
Catch ex As Exception
If langue = "en" Then
messageaff = "An error occurred during the updating access of the consultations list"
infoaff = "Writing file error"
Else
messageaff = "Une erreur est survenue au cours de la mise à jour de la liste des consultations"
infoaff = "Erreur écriture fichier"
End If
MessageBox.Show(messageaff, infoaff, MessageBoxButtons.OK, MessageBoxIcon.Warning)
End Try
End Using
End Sub |
Partager