Question

用asp如何同时向ACCESS数据库中添加多条记录

用asp如何同时向ACCESS数据库中添加多条记录

Answer 1

Sub WriteData()
Dim recCnt,i
Dim UserID,UserName,Score
Dim SqlStr
//用于动态取得需要录入多少条记录
recCnt=cint(request.form("recCnt"))
//批量录入数据
for i=1 to recCnt
UserID=trim(request.form("UserID")(i))
UserName=trim(request.form("UserName"凳茄罩)(i))
score=trim(request.form("score")(i))
sqlStr="insert into Users(UserID,UserName,score)value(
'"枣闹sqlStr=sqlStr&UserID&"',
'"sqlStr=sqlStr&UserName&"',
'"sqlStr=sqlStr&UserName&"'纳嫌)"
Response.Write sqlStr
conn.execute(sqlStr)
next
conn.close
response.write"数据成功录入"
End SUB

Answer 2

rs("a"亩察)=aa
rs("b")=bb
rs("扰耐哪c")=cc
rs("d"缓码)=dd
rs.update

Answer 3

多条记录？亩蔽乱多个insert语句么迅档？用循环啦
比如：
dim i
i=0
do while i<10
conn.execute("并稿insert into ......")
i=i+1
loop