Hi!

I was wondering if you people also find the LastLoginDate to be 2 hours off in the aspnet.membership table. It is a little bit annoying as I show the name and time of the last 5 logins.

Regards,

Tommy

tsaren:

I was wondering if you people also find the LastLoginDate to be 2 hours off in the aspnet.membership table. It is a little bit annoying as I show the name and time of the last 5 logins.

Mine's five hours off.  If you want to correct this, move two time zones west.  :)

It's GMT, you need to do an offset for the correct time.  This could be done before saving the date to the database, or in the retrieval for display.

Jeff

>move two time zones west.  :) ha ha!

You can't change the date from UTC before it's saved in this case, as different login controls will set this date and expect it to be in UTC.

What you need to do is change it to local time when you display it, which is easy:

dim utcdate as date
... get the date from database
localdate = utcdate.ToLocalTime()

Hi again!

I got the sql for it:

/Tommy

Hiya Tommy,

that will work, but only if you live in Sweden and there's no daylight savings time :)

Where I live, sometimes we are 7 hours different from UTC, sometimes 8.

The date function ToLocalTime() takes this into account, so if you use that, you can move your software to New York and it will still work correctly. That might never be an issue for you, but I think it's a good practice to try to write code that's going to run properly regardless of where it's hosted.

I think this is why the date is stored as UTC in the first place, because it means you *can* write code that converts it to local time (not just server local time either, maybe you'll eventually want to time to appear in the user's local time, so if I browse to your site on the other side of the world, the time I see is *my* local time, not Swedish time).

You are so right "Herr Lunch"! /hey thanks again for the forum. It is working great.

This does not fix Lex problem, but it was the final solution to my problem.

 <ItemTemplate>
                            <%# Convert.ToDateTime(Eval("lastlogindate")).ToLocalTime() %>
 </ItemTemplate>

Regards,

Tommy

Lex,

Please show your SQL statement (blahblahblah WHERE userid = @userid) so we can take a look.

Thanks.

Hi,

SELECT     distinct top 1 UserId, LastLoginDate
FROM         vw_aspnet_MembershipUsers
WHERE     (UserId = @UserId)

With the where clause builder I choose for:

1. column: UserId
2. operator: =
3. Source: Querystring
4. Paramater properties ????
5. default value ????

That's about it.

Regards,

Lex

Lex,

Are you sure that you are passing the UserId not the UserName?

The user id is a long uniqueidentifier.

Thanks.

Hi,

Well I choose it because it defines the user uniquely, (so does Username I guess)

In both cases my problem seems to be to hold it against the current logged-in user.

Thanks,

Lex

Hi lex here is an example of how to build the select statement in the script and call it from the sqldatasource.

I find this easier for manipulating the query string. You could also place this in the App_Code folder so it can be called by other pages. For now try it in the page you are working on.

Public Sub Get_Authentication(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreLoad

What exactly are you trying to do Lex (in terms of what the final result is supposed to be)?

Getting the current user last login date doesn't need a database query, it's as simple as

Hi Frank,

I transposed your code as follows:

Dim GridViewSQL As String

Dim UserIdhaal As String

Hi Mark,

This looks short and neat I must say. But as I am trying to put it in default.aspx I don't know where exactly to put it.

Sort of the same problem as described in the previous post: When the page loads the user is not logged on yet.

But it certainly is a piece of code that could come in handy at all sorts of pages.

Thanks,

Lex

I'm afraid I'm a little confused, what is the reasoning for sqldta and jawat

I was just showing how you could build a query string in the script for a Sqldatasource, if your just trying to fill a gridview that uses Sqldatasource6 then just use SqlDatasource6.selectcommand =  GridViewSql.

Dim sqldta As System.Web.UI.WebControls.Login = lv1.FindControl("Login1")

Dim jawat As SqlDataSource = CType(sqldta.FindControl("SqlDataSource6"), SqlDataSource)

jawat.SelectCommand = GridViewSQL

I do believe Mark has offered a better solution, you may just need to play around with it to get it to do what you want. The MembershipProvider is a great feature with Asp.net and should be a priority for anyone to learn(including myself)