This may have been asked a few times, but the forum's search capability seems to be timing out tonight..

Is it possible to use an DNN user profile properties directly within a SQL DataSource as a SQL parameter?

For example:

select UserName from Users where UserID=@UserID

What "setting" should I use within the SQL datasource to properly pass the user ID? (Session, Cookie, Control, etc..)

Thanks!

jasen

if you are calling your stored procedure, you may pass userid from httpcontext.