sqlStr="insert into student values('"+name+"','"+address+"','"+phone+"','"+age+"')"

[sohe]

sqlStr="insert into student values('"&name&"','"&address&"','"&phone&"','"&age&"')"
sqlStr="insert into student values('"+name+"','"+address+"','"+phone+"','"+age+"')"
conn.open sqlStr

name,address,phone,age 都是text

请问错在哪，谢谢解答！！！在线等！！
用ADO RS又是如何写入的？？？

[menrock]

conn.execute(sqlStr)

[jarraytan]

sqlStr="insert into student (name,address,phone,age) values('"&name&"','"&address&"','"&phone&"','"&age&"')"

用ADO的话：
rs.open "student",conn,1,3
rs.addnew
rs("name")=name
rs("phone")=phone
rs("age")=age
rs.update
rs.close

[jarraytan]

sqlStr="insert into student (name,address,phone,age) values('"&name&"','"&address&"','"&phone&"','"&age&"')"
conn.execute sqlStr

[menrock]

set rs= Server.CreateObject("adodb.recordset")
sqlstr="select * from student"
rs.open sqlstr,conn,1,3
rs.addnew
rs("name")=name
rs("address")=address
rs("phone")=phone
rs("age")=age
rs.update
set rs=nothing

[sohe]

rs.open "student",conn,1,3
'sqlstr="select * from student"
'rs.open sqlstr,conn,1,3
rs.addnew
rs("name")=name
rs("phone")=phone
rs("age")=age
rs.update
rs.close
这两种方法是正确的，
用SQL还不进去？？？？？