how to get user's UserId

[Jeff]

Hey

ASP.NET 2.0

I'm wondering how to get the users UserId (the uniqueidentifier value stored
in the UserId column in aspnet_Users)??

I'm wondering because I want to add some more tables to the ASPNETDB.MDF
database, and use the UserID as foreign key in this custom tables....

I can't see the userId property from the Profile object....

I know I can do soemthing like this, but thought maybe there is a better
way:
select c.*
from aspnet_users a, mytable c
where a.UserId = c.UserId and a.UserName = "jeff"

What is your suggestion?

Jeff

[Jon Paal]

this may lead you to a solution

http://weblogs.asp.net/scottgu/archi...esources-.aspx

"Jeff" <it************@hotmail.com.NOSPAMwrote in message news:OS**************@TK2MSFTNGP05.phx.gbl...

Hey

ASP.NET 2.0

I'm wondering how to get the users UserId (the uniqueidentifier value stored in the UserId column in aspnet_Users)??

I'm wondering because I want to add some more tables to the ASPNETDB.MDF database, and use the UserID as foreign key in this
custom tables....

I can't see the userId property from the Profile object....

I know I can do soemthing like this, but thought maybe there is a better way:
select c.*
from aspnet_users a, mytable c
where a.UserId = c.UserId and a.UserName = "jeff"

What is your suggestion?

Jeff