求解呀，asp同时添加多条同样记录。如何实现。我的代码不成功。55。。

if request.QueryString("action")="save" then

sl=trim(Request.Form("sl")) '自定义一个条数量.

set rs=server.CreateObject("adodb.recordset")

rs.open "select * from kcxs",conn,1,3

for i=0 to sl

rs.addnew

rs("jhrq")=trim(request("jhrq"))

rs("xsrq")=trim(request("xsrq"))

rs("mc")=trim(request("mc"))

rs("cplx")=trim(request("cplx"))

rs("jhj")=trim(request("jhj"))

rs("xsj")=trim(request("xsj"))

rs("gys")=trim(request("gys"))

rs("khmc")=trim(request("khmc"))

rs("lr")=trim(request("xsj"))-trim(request("jhj"))

rs("bzq")=trim(request("bzq"))

rs("bz")=trim(request("bz"))

rs("lx")=trim(request("lx"))

rs("jlr")=trim(request("jlr"))

rs("jlrq")=trim(request("jlrq"))

rs.update

next

end if

rs.close

set rs=nothing

response.write "<script language=javascript>alert('成功添加["&i&"]条记录！')window.location.href='kcgl_add.asp'</script>"

response.End

把所有得记录存入一个集合，在用事务一次性存入数据库 参考代码如下（仅供参考）：

SqlConnection myConnection = new SqlConnection("Data Source=localhostInitial Catalog=NorthwindIntegrated Security=SSPI")

myConnection.Open()

SqlTransaction myTrans = myConnection.BeginTransaction()//使用New新生成一个事务

SqlCommand myCommand = new SqlCommand()

myCommand.Transaction = myTrans

try

{

for(....)//这儿做循环插入

{

myCommand.CommandText = "Update Address set location='23 rain street' where userid='0001'"

myCommand.ExecuteNonQuery()

}

myTrans.Commit()

}

catch(Exception e)

{

myTrans.Rollback()

}

finally

{

myConnection.Close()

}

---