最近测试发现,RecordSet 对象在用open执行SQL Insert语句后会自动关闭。
str_sql="select * from PinZhong where name='"&PingMing&"'" rs.Open str_sql, Conn, 1,1 response.Write "status:"&rs.State&"<br>" str_sql="insert into PinZhong (name) values ('b')" rs.Close response.Write "status:"&rs.State&"<br>" rs.Open str_sql, Conn, 1,1 response.Write "status:"&rs.State&"<br>"