1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
ocM3.CommandText = "insert into Reglement_client" & _
"(code, client,Facture" & _
",type_fac ,Date_Reg,Type_Reg " & _
",Banque,Npiece,Montant,date_Echeance" & _
")Values" & _
"( '" & id1 & "', '" & txtNomClinet.Text & "' , '" & txtcode.Text & "' " & _
",'" & type_Facture1 & " ','" & txtDate.Text & "','" & type_reg1 & _
"','" & banque1 & "', '" & npiece1 & "','" & montant1 & "' ,'" & dateEch1 & "'" & _
" ) where (ISNULL([Encaisse]));"
ocM3.ExecuteNonQuery()
MessageBox.Show(ocM3.CommandText.ToString)
ocn2.Close() |
Partager