How to display data of logged in user?

2asp.net · April 19th, 2010, 01:18 AM

Imar, I'm struggling to figure out how to display data (from a sql server database) specific to the logged in user. I've setup up the login control and used WSAT to setup the users. Your help would be greatly appreciated. I've looked many places to find out how to do this. Your book has been outstanding for me to learn ASP.net.

Imar · April 19th, 2010, 02:25 AM

Hi there,

When yoou're using EF and have a query in Code Behind, you can use Context.User.Name to find out the current user and use that in a where clause.

E.g.:

Code:

 
var whatever = from s in someDataSource
                      where s.UserName == Context.User.Name
                      select s

For tor the other controls, this search may help: http://www.google.com/#hl=en&q=conte...10401dfb0a78c2

Cheers,

Imar

santaclaus1989 · April 20th, 2010, 05:46 AM

thanx aloooooooooooooot