Newbie; Getting Data from database question

[carlg]

I'm new to ASP 2.0 so I have some questions.

I have mutiple users of my website.

Let's say I have a db table called mytable.
There is a column on this table called userid which tells which of the users to which this row belongs.

I put a login view control on my page.

Where do I pull the value of the current logged in user from so I can write a query like the following:

Select * from mytable where userid = "whatever user us logged in"

I only want to display the rows for the user that is logged in.

Thanks for the help

Carl

 

[jbenson001]

Have you tried: User.Identity.Name ?

 

[carlg]

No, I didn't

I will try

Thanks for the info!

 

[jbenson001]

no problem.