Retrieving UserID

[silpa]

Hi,
I am doing a web application using c# asp.net 2.0.

In the login page, I placed Login control.
Email Address is given as Username.
i.e.,

UserName---------<EmailAddress >
Password----------<something>
When I press the login button it goes to a default page named myprofile.aspx

myprofile.aspx should display all the information about the logged in user based
on his userid.
But here EmailAddress is given as username.
For example if abc@a.com is email address and its user id=9

how to retrieve user id based on the EmailAddress given in login control.

Please help me by sending code.

Thanks,
Silpa

[debasisdas]

This logic can simply be implemented at Database level.