I am using a SqlDatasource and need to set a SelectParamter to the ProviderUserKey (The GUID of the user when Profiles are enabled)
Can anyone tell me whether it is possible and How?
I am currently using the session state to store it in and then using the session=... to get the value into the parameter.
Is there a direct way of passing this value into a SelectParameter when using a SqlDataSource?
Thanks in advance.
Hi,
As far as I know, there isn't any direct way to use the user GUID as parameter.
The only way I can think is to use custom code to query the GUID and put it in the querystring or session.
HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!
|||Thanks|||Thanks for taking the time.
I am already using the session state.(querystring option would raise serious security issues).
Just in case anyone else is interested, you can also use the inserting/updating events on the SqlDatasource to assign the GUID to the specific parameter.
I just thought there might be a way of doing it directly.
No comments:
Post a Comment