帮忙看看哪里错了

shitcai 发布于 2008-06-24 22:51， 683 次点击

<%


     set conn=server.createobject("ADODB.CONNECTION")
     conn.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & DefaultDir &server.mappath("1.mdb")&";"
     set rs=server.createobject("ADODB.recordset")

     Rs.Open "学生",conn,3,3
     Rs.AddNew
     Rs.("学号").value="200702"
     Rs.("姓名").value="李四"
     Rs.("年龄").value="19"
     Rs.UpDate
     rs.close

    set conn=nothing
%>
看了快一个网上就是看不出来第一天接触asp多见谅

4 回复

anlige2008-06-25 01:54

<%
     set conn=server.createobject("ADODB.CONNECTION")
     conn.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & DefaultDir &server.mappath("1.mdb")&";"
     set rs=server.createobject("ADODB.recordset")
     Rs.Open "select * from 学生",conn,1,3
     Rs.AddNew
     Rs.("学号")=200702
     Rs.("姓名")="李四"
     Rs.("年龄")=19
     Rs.UpDate
     rs.close
     set rs=nothing
     conn.close
     set conn=nothing

anlige2008-06-25 01:56

<%
     set conn=server.createobject("ADODB.CONNECTION")
     conn.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & DefaultDir &server.mappath("1.mdb")&";"
     set rs=server.createobject("ADODB.recordset")
     Rs.Open "select * from 学生",conn,1,3
     Rs.AddNew
     Rs("学号")=200702
     Rs("姓名")="李四"
     Rs("年龄")=19
     Rs.UpDate
     rs.close
     set rs=nothing
     conn.close
     set conn=nothing
%>

ljroger7282008-06-25 09:26

<%
     set conn=server.createobject("ADODB.CONNECTION")
     conn.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & DefaultDir &server.mappath("1.mdb")&";"
     set rs=server.createobject("ADODB.recordset")
     Rs.Open "select * from 学生",conn,1,3
     Rs.AddNew
     Rs("学号")=200702
     Rs("姓名")="李四"
     Rs("年龄")=19
     Rs.UpDate
     rs.close
     set rs=nothing
     conn.close
     set conn=nothing
%>

shitcai2008-06-26 13:04

呵呵谢谢了