在记录集中插入记录

K.PT/oAX1}0'在记录集中插入记录

f,|\n0q-D1bA.B0'建立连接对象
h1{ P3\
~d[q4D0Set bjconn = CreateObject("adodb.connection")

*D"n5E1pm/S'V3v'o0'建立记录集对象
$] Y3{^%vV;P0Set bjrecordset =CreateObject("adodb.recordset")51Testing软件测试网zh |QKg^

\T#q Q$j{+bu-PD0objconn.Open _51Testing软件测试网-uD6l'EG*J-q;IB
"Provider = SQLOLEDB;Data Source=.;Trusted_Connection =yes;"&_
p-KR K$tu4oO Bd0"Initial Catalog =Cwxt;User Id =sa;password=1;"51Testing软件测试网1u)q(IQ
h Z
objrecordset.Open "select * from tbl_user",objconn,3,3

objrecordset.AddNew()
w5f3FDw*T+z\;jB0E0objrecordset.Fields(0).Value ="1"51Testing软件测试网N|Y+b1O{%^ v:v%br:j
objrecordset.Fields(1).Value ="22"51Testing软件测试网 _e9UKZ0B
objrecordset.Fields(2).Value ="33"51Testing软件测试网*OZ'W}3mY
objrecordset.Update()51Testing软件测试网F5P k
P8P5x

objconn.Close51Testing软件测试网 Kva(B`
objrecordset.Close51Testing软件测试网 yo u_2c Z[i
51Testing软件测试网`-v-D3X d)X:t!r