>>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.
I checked the article, thanks a lot again. Looks like I would also need to adjust my GridView because I want to show Last Activity Date in local date format.
If it's not broken, fix it until it is.
My Blog