Automated logon membership

Hi,

I am using the membership tools that ship with ASP.NET 2.0

The basic proceduer for a new user follows the steps listed below.

• User comes on site,
• User clicks Create user
• User is taken to a profile page
• User fills in profile.
• Email is sent to user
• User is taken to a waiting page that tells them to check there email for registration.
• User gos to there email progrem and clicks on the linkin the registraion email that has a code in the querystring.

This takes them back on site. and this is where my problem lies.

I want the user to be automaticaly loged in when they come back on site. As I dont know there password and cant get there password from the DB as it is Hashed I cant log them on.

So is there a way to log a user on to a site if you dont know there password. At this point I do know the UserID i can work this out from the code that comes back from the registration email.