sql ="INSERT INTO service (col1,col2,col3,..)values(@Code_Serv,@Nom_Serv,@Code_Direc,@test1, ...) "
<code class="vb_keyword1">Setcmd
=
NewADODB
.
Command
.
CommandType
=</code>adCmdText
cmd<code class="vb_function">.
CommandText
=
sql
Setcmd
.
ActiveConnection
=cnn
'
cnn
est
un
objet
Adodb.Connection
.
Parameters
.
Item(
"
@</code>Code_Serv
<code class="vb_literal1">
")
.
Value
=
1000
.
Parameters
.
Item(
"
@</code>Nom_Serv
<code class="vb_literal1">
")
.
Value
=
"
....
"
.
Parameters
.
Item(
"
@...
")
.
Value
=
"
....
"