求一个简单的通过ASP网页读写ACCESS表的代码
各位大虾,本人初学ASP想求一个简单的通过ASP网页读写ACCESS表的代码。
------解决方案--------------------http://zhidao.baidu.com/question/22455217.html
------解决方案-------------------- <%datafile=mydata.mdb '数据库路径 
 connstr= "Provider=Microsoft.Jet.OLEDB.4.0;password=;Data Source= "&Server.MapPath(datafile) 
 Set conn=Server.CreateObject( "ADODB.Connection ") 
 conn.open ConnStr 
  '写入数据 
 set rs=server.createobject( "adodb.recordset ") 
 sql= "select * from [mytable] " 
 rs.open sql,conn,1,3 ' 
 rs.addnew 
 rs( "id ")=1 
 rs( "content ")= "写入数据 " 
 rs.update 
 rs.close 
 set rs=nothing 
  '读取数据 
 set rs=server.createobject( "adodb.recordset ") 
 sql= "select * from [mytable] " '查询表mytable 
 rs.open sql,conn,1,1 ' 
 do while not rs.eof '如果表中有数据的话,循环输出 
 response.write rs( "id ")& " <p>  " 
 response.write rs( "content ")& " <p>  " 
 rs.movenext 
 loop 
 rs.close 
 set rs=nothing 
 conn.close '关闭数据库 
 set conn=nothing '释放数据库连接%>  
 基本上就这样了