1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Sub InsertLocataire()
Dim MaRequete As String = "INSERT INTO LOCATAIRES (Nom, Adresse,Ville,Pays) VALUES (?,?,?,?)"
Dim DataSource = "C:\Users\ROLAND KOFFI\Documents\Visual Studio 2010\Projects\WindowsApplication3_LOYERS\WindowsApplication3_LOYERS\GestionLoyers1.accdb"
Using cn As New OleDbConnection("PROVIDER=Microsoft.ACE.OLEDB.12.0;Data Source =" & DataSource), cmd As New OleDbCommand(MaRequete, cn)
With cmd.Parameters
.AddWithValue("?", Me.txtNom.Text)
.AddWithValue("?", Me.txtAdresse.Text)
.AddWithValue("?", Me.txtVille.Text)
.AddWithValue("?", Me.txtPays.Text)
End With
Try
cn.Open()
cmd.ExecuteNonQuery()
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Using
End Sub |
Partager