1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
Try
Dim connexion As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=K:\AP\AP 1 - VB.net contrat électrique\BDDContrat.mdb;Persist Security Info=False")
Dim nombre As Integer
connexion.Open()
'Dim insertion As SqlCommand = New SqlCommand("Insert Into client Values ('','txt_nom.text','txt_prenom.text','txt_raisonSociale.text','txt_adresse.text','txt_commune.text','txt_codePostal.text', 'txt_telFixe.text','txt_telPort.text','txt_mail.text', 'txt_interlocuteur.text')")
'cmd.CommandText = "Insert Into client Values ('','txt_nom.text','txt_prenom.text','txt_raisonSociale.text','txt_adresse.text','txt_commune.text','txt_codePostal.text', 'txt_telFixe.text','txt_telPort.text','txt_mail.text', 'txt_interlocuteur.text')"
Dim RequeteSQL As String
Dim requete2 As String
requete2 = "Select numClient From Client"
Dim commande As New OleDbCommand(requete2, connexion)
commande.ExecuteNonQuery()
nombre = numClient + 1
RequeteSQL = "Insert Into client Values ('" & nombre & "','" & txt_nom.Text & "','" & txt_prenom.Text & "','" & txt_raisonSociale.Text & "','" & txt_adresse.Text & "','" & txt_commune.Text & "','" & txt_codePostal.Text & "', '" & txt_telFixe.Text & "','" & txt_telPort.Text & "', '" & txt_mail.Text & "', '" & txt_interlocuteur.Text & "')"
Dim cmd As New OleDbCommand(RequeteSQL, connexion)
cmd.ExecuteNonQuery()
'Dim DataA As New OleDbDataAdapter(RequeteSQL, connexion)
Catch ex As Exception
MsgBox(ex.ToString)
End Try |