我是菜我怕谁?
set conn=server.createobject("adbod.connection")conn.open "driver={microsoft access driver(*.mdb)}:dbq="&server.mappath("mydata.mdb")
sql=select * from gbook where......
cn.excute sql
和
set conn=server.createobject("adbod.connection")
set rs=server.createobject("adbod.recordset")
conn.open "driver={microsoft access driver(*.mdb)}:dbq="&server.mappath("mydata.mdb")
sql=select * from gbook where......
rs.open sql cn 1,1
这2句操作数据库结果都一样吧.
谁能帮我列一下,有关recordset,connection,command
这3个对象分别操作数据库的代码.谢谢了!!