asp+| Data | Database relaxing Life Network (relaxlife.net) Asp+sql Personal Summary of various operations on the database
/**********************************************************************
*
* 1,---------Asp+sql Personal Summary of various operations on the database
*
* If you need more code, please go to: http://www.relaxlife.net feel good help me top!
*
*
*********************************************************************/
<%
Query method
----------------------------(1)-------------------------------
Set rsworkuserinfo = Server.CreateObject ("ADODB. RecordSet ")
strSQL = "Select UserSID, LoginName, UserName, Password"
strSQL = strSQL & "from Users"
strSQL = strSQL & "Where usersid=" & Sqlstr (Tuserid)
If rsworkuserinfo.state = 1 Then
Rsworkuserinfo.close
End If
Rsworkuserinfo.open strsql,conn,1,1
If not rsworkuserinfo.eof Then
LoginName = Rsworkuserinfo ("LoginName")
UserName = Rsworkuserinfo ("UserName")
Password = Rsworkuserinfo ("Password")
End If
Rsworkuserinfo.close
Set Rsworkuserinfo = Nothing
----------------------------(2)-------------------------------
strSQL = "Select UserSID, LoginName, UserName, Password"
strSQL = strSQL & "from Users"
strSQL = strSQL & "Where usersid=" & Sqlstr (Tuserid)
Set rsfind = Conn.execute (strSQL)
If not rsfind.eof Then
LoginName = Rsfind ("LoginName")
UserName = Rsfind ("UserName")
Password = Rsfind ("Password")
End If
Rsfind.close
Set Rsfind = Nothing
Modify method
----------------------------(1)-------------------------------
Set rsworkuserinfo = Server.CreateObject ("ADODB. RecordSet ")
&nbs
