¹ØÓÚaspÖÐÓà insert into²åÈëµÄÒ»¸öÎÊÌâ

<%

User=request.form("User")
Password=request.form("Password")

conn.Execute("insert into admin(user, password) Values('" & user & "','" & password & "')")
'rs.open "select * from admin",conn,1,3
'rs.addnew
'rs("user")=User
'rs("password")=Password
'rs.update

'rs.close
'set rs=nothing
conn.close
set conn=nothing

ÓÃaddnew·½·¨²åÈëûÎÊÌ⣬¾ÍÊÇÓÃinsert into²»ÄܲåÈ룬ºóÀ´ÎÒ»»ÁËÒ»¸öÊý¾Ý¿âÇý¶¯£¬¾ÓÈ»¾Í¿ÉÒÔÁË£¬ÕâÊÇÔõô»ØÊ°¡
ÄѵÀjetµÄÒýÇæ¾Í²»ÄÜÓÃinsert into¡£
±¨´í£ºMicrosoft JET Database Engine ´íÎó '80040e14'


'conn.open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("lyb.mdb") )
conn.open("Dbq=" & Server.Mappath("lyb.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}" )
½«jetÇý¶¯»»³ÉÏÂÃæµÄÆÕͨÇý¶¯¾Í¿ÉÒÔÁË£¬¹ÖÊ°¡

---

Ö±½Ó
insert into admin Values('" & user & "','" & password & "')
ÄØ£¿

---

sqlÓï¾ä´íÎó

---

¿´¿´user»òÕßpasswordÊÇ·ñÊDZ£Áô×Ö¡£
addnew»á°ïÄã´¦Àí±£Áô×ֵijåÍ»¡£ÄãµÄÓï¾äûÓÐ×öµ½¡£

---

conn.Execute("insert into admin([user], [password]) Values('" & user & "&