name=request("textfield1")
sex=request("select")
age=request("textfield2")
xueli=request("select2")
zhuanye=request("select3")
biyeyear=request("textfield3")
tel=request("textfield4")
company=request("textfield5")
email=request("textfield6")
note=request("textfield7")set rs=server.createobject("adodb.recordset")
conn = "DBQ=" + server.mappath("mydb.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
sql="insert into mytable(name,sex,age,xueli,zhuanye,biyeyear,tel,company,email,note) values('"&name&"','"&sex&"','"&age&"','"&xueli&"','"&zhuanye&"','"&biyeyear&"','"&tel&"','"&company&"','"&email&"','"¬e&"')"rs.Open sql,conn,1,1
response.write "<script language=JavaScript>" & chr(13) & "alert('同学信息添加成功!');"&"window.location.href = 'index.asp'"&" </script>"
rs.Close
set conn=nothing
set rs=nothing
------------------------------------------------
出错信息如下:(用recordset方法读数据库时无误,每涉及到写时,出错)
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21' ODBC 驱动程序不支持需要的属性。 /caida/admin/adreg.asp, 行28 请高手赐教(最好附源码做例子,谢!)
sex=request("select")
age=request("textfield2")
xueli=request("select2")
zhuanye=request("select3")
biyeyear=request("textfield3")
tel=request("textfield4")
company=request("textfield5")
email=request("textfield6")
note=request("textfield7")set rs=server.createobject("adodb.recordset")
conn = "DBQ=" + server.mappath("mydb.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
sql="insert into mytable(name,sex,age,xueli,zhuanye,biyeyear,tel,company,email,note) values('"&name&"','"&sex&"','"&age&"','"&xueli&"','"&zhuanye&"','"&biyeyear&"','"&tel&"','"&company&"','"&email&"','"¬e&"')"rs.Open sql,conn,1,1
response.write "<script language=JavaScript>" & chr(13) & "alert('同学信息添加成功!');"&"window.location.href = 'index.asp'"&" </script>"
rs.Close
set conn=nothing
set rs=nothing
------------------------------------------------
出错信息如下:(用recordset方法读数据库时无误,每涉及到写时,出错)
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21' ODBC 驱动程序不支持需要的属性。 /caida/admin/adreg.asp, 行28 请高手赐教(最好附源码做例子,谢!)
set rs=server.createobject("adodb.recordset")
conn.open "driver={microsoft access driver (*.mdb)};dbq="& server.mappath("mydb.mdb");uid=;pwd="
rs.open sql,conn,3
.....//這樣一定可以
set rs=server.createobject("adodb.recordset")
conn = "DBQ=" + server.mappath("mydb.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
sql="insert into mytable(name,sex,age,xueli,zhuanye,biyeyear,tel,company,email,note) values('"&name&"','"&sex&"',"&age&",'"&xueli&"','"&zhuanye&"','"&biyeyear&"','"&tel&"','"&company&"','"&email&"','"¬e&"')"conn.execute(sql)
response.write "<script language=JavaScript>" & chr(13) & "alert('同学信息添加成功!');"&"window.location.href = 'index.asp'"&" </script>"
conn.close
set conn=nothing
name=request.form("textfield1")