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
|
' On crée un nouvel objet commande
cmd = ccasa.CreateCommand()
' Création des paramètres sur la commande
With cmd.Parameters
.Add(New SqlParameter("@AR_Ref", SqlDbType.VarChar, 19))
.Add(New SqlParameter("@AR_Design", SqlDbType.VarChar, 69))
.Add(New SqlParameter("@FA_CodeFamille", SqlDbType.VarChar, 11))
.Add(New SqlParameter("@AR_UniteVen", SqlDbType.SmallInt, 10))
.Add(New SqlParameter("@AR_SuitStok", SqlDbType.SmallInt, 8))
.Add(New SqlParameter("@AR_HorStat", SqlDbType.SmallInt, 25))
.Add(New SqlParameter("@FORNISSEUR", SqlDbType.VarChar, 15))
.Add(New SqlParameter("@Creation", SqlDbType.SmallDateTime, 9))
End With
' Remplissage des valeurs de paramètre
With cmd
.Parameters("@AR_Ref").Value = TextBox1.Text
.Parameters("@AR_Design").Value = TextBox2.Text
.Parameters("@FA_CodeFamille").Value = TextBox3.Text
.Parameters("@AR_UniteVen").Value = CInt(TextBox4.Text)
.Parameters("@AR_SuitStok").Value = CInt(TextBox5.Text)
.Parameters("@AR_HorStat").Value = CInt(TextBox6.Text)
.Parameters("@FORNISSEUR").Value = TextBox7.Text
.Parameters("@Creation").Value = TextBox8.Text
End With
cmd.CommandText = "insert into ARTICLECASA(AR_Ref,AR_Design,FA_CodeFamille,AR_UniteVen,AR_SuitStok,AR_HorStat,FORNISSEUR,Creation) values(@AR_Ref,@AR_Design,@FA_CodeFamille,@AR_UniteVen,@AR_SuitStok,@AR_HorStat,@FORNISSEUR,@Creation)"
cmd.ExecuteNonQuery() |
Partager