Ok, this "should" be easy for you, just not me. I have a login page
that looks for a username and password in a SQL database and if they
match then let them in....however, now what I want to do is IF the
username and password DOES match I now want to update the database of
when that happend.
CURRENT CODE:
Dim Conn As SqlConnection
Dim Rdr As SqlDataReader
Dim strConn As String = AppSettings("oliveConnect")
Dim strSQL As String = "select ID, username, password from
USERS where username = '" + loginusername.Text + "' AND password = '"
+ loginpassword.Text.Trim() + "'"
Conn = New SqlConnection(strConn)
Dim Cmd As New SqlCommand(strSQL, Conn)
Conn.Open()
If Cmd.ExecuteScalar() <> "" Then
Rdr = Cmd.ExecuteReader()
'HERE I NEED TO SAY SOMETHING LIKE UPDATE USERS SET
TIMESTAMP = NOW() WHERE ID = strSQL.ID <---This pulling from the ID in
the above query.
------------------------ Yahoo! Groups Sponsor --------------------~-->
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
