源代码username=Trim(request.form("username"));
userpwd=Trim(request.form("password"));
set conn=server.createobject("adodb.connection");conn.open"provider=sqloledb.1;persistsecurityinfo=true;userid=sa;password=99611linlin;initial catalog=asptest;datdsource=ouyang_6b40bde2"
set rst=server.createobject("adodb.recordset")
strsql="select*from userlogon where username="&"'"&username&"'"&"and pwd="&"'"&userpwd&"'"
rst.open strsql,conn,3
if rst.recordcount=0 then
response.redirect("logonerror.asp")
else
session("username")=rst.fields("username")
session("userid")=rst.fields("id")
response.redirect("logonsuccess.asp")
end if

那怎么改呀？急呀！请各位大侠指点一下，

[此贴子已经被作者于2007-6-2 11:00:37编辑过]