在记录集中插入记录

`Pu'Fj/v#xj0'在记录集中插入记录

.os0M$p _$G!b0'建立连接对象
{5\2C`|E4|X;F0Set bjconn = CreateObject("adodb.connection")

JFb:Bbsn?0'建立记录集对象
^u4rMT~x'S&N0Set bjrecordset =CreateObject("adodb.recordset")

objconn.Open _
4I%}9s4EQc_ v0"Provider = SQLOLEDB;Data Source=.;Trusted_Connection =yes;"&_
[M WO1S0"Initial Catalog =Cwxt;User Id =sa;password=1;"
3W$Ax A.O+iZ+M0objrecordset.Open "select * from tbl_user",objconn,3,351Testing软件测试网}L$@BIgsW7UB

objrecordset.AddNew()
,g`%`/l0i0objrecordset.Fields(0).Value ="1"51Testing软件测试网N bBMQ7Cs
objrecordset.Fields(1).Value ="22"51Testing软件测试网 ^fV
d {.i%}:p
objrecordset.Fields(2).Value ="33"
#D.QS[ M-F~U0objrecordset.Update()

+J*L4nk'[0objconn.Close
SbP9cj'a0objrecordset.Close51Testing软件测试网4nwd[X7m$H2wjRN ?
51Testing软件测试网-O`&L"k`!o6F