Hi folks,

What I am trying to achieve is when a user logs into my website their username and password is checked against a table in SQL, if their details exists it puts a time stamp in the SQL table of when they last logged in.

Now I got the first part working without a problem, users loggin into and out, but I cannot for the life of me get my head around the last part. In the SQL table I have a field named [Username], a field named [Password], and a field named [Last Login].

I am using Visual Studio 2005 with VB, if anyone has got any code exmaples please let me know.

Thanks!!

Let Com is command Object
Update logintable set [Last Login]=@log where [username]=@ur
Com.Parameters.Add("@log",SqlDbType.DateTime,Syste m.DateTime.Now.ToString())
com.Parameters.Add("@ur",usernm)

Bijgupt