Var row As New DatabaseRow
// ID will be updated automatically
row.Column(“DossierNo”) =order.N°Dossier.text
row.Column(“BonDeTravail”) = order.BonDeTravail.text
row.Column(“Nom”) = order.nom.text
row.column(“Adresse”)=order.adresse.text
row.column(“bureau”)=order.bureau.text
row.column(“ville”)=order.ville.text
row.column(“province”)=order.province.text
row.column(“CodePostal”)=order.CodePostal.text
row.column(“Téléphone”)=order.Téléphone.text
row.column(“Poste”)=order.Poste.text
row.column(“Courriel”)=order.Courriel.text
row.column(“PersRess”)=order.PersRess.text
row.column(“vendeur”)=order.vendeur.text
row.Column(“DateOuverture”) =order.DateOuverture.text
row.Column(“DateRequise”) = order.DateRequise.text
row.Column(“Soumission”) = order.Soumission.text
row.column(“description”)=order.Desc.text
row.column(“CommClient”)=order.commclient.text
row.column(“commcourtier”)=order.commcourtier.text
row.column(“prixvente”)=order.prixvente.text
Try
JobData.AddRow(“customers”, row)
JobData.CommitTransaction
Catch error As DatabaseException
MessageBox("Error: " + error.Message)
JobData.RollbackTransaction
End Try