>In this line:
>
>SqlCommand cmd = new SqlCommand("UPDATE aspnet_Users SET LastActivityDate = @LastUpdatedDate WHERE UserId = '" + userId + "'", conn);
>
>What is the value of userId when it executes?
>
>As to why UTCNow see this:
>
>
http://aspnet.4guysfromrolla.com/articles/081507-1.aspx>
>John
>
Thanks a lot for coming to the rescue. This line seems to execute repeatedly with various GUIDs. I was watching username in the watch window and it showed users with the same SiteID as myself.
I'm going to check the link tomorrow, too late right now.
Thanks again for your help.
One more question - why in the UPDATE statement where is
username = lower(@username) ? Why do we use lower is SQL Server is case insensitive ?
And why we add user ID as is and not as a parameter in the string?
Thanks again.
If it's not broken, fix it until it is.
My Blog