Data Presentation Controls

Re: SelectParameters

carrics3 — Sat, 31 Mar 2007 14:09:12 GMT

Im looking to user the User ID in my query.

Im currently retriving it in the C# Page.

How can i reference it within the query?

I have made the variable public within the C# Page

This is the piece of code im using within the select parameters

DefaultValue="<%= UserNum %>

Or is there any easier way of getting this value without having to use the C# Page?

bitflusher — Fri, 30 Mar 2007 09:00:48 GMT

i know this is solved but for users who use the search:

you can also get it form the useprofile

<asp:ProfileParameter Name="myparameter" PropertyName="Username" />

</SelectParameters>

alockrem — Tue, 19 Sep 2006 13:56:00 GMT

Great! I appreciate your help.

pkellner — Mon, 18 Sep 2006 17:03:14 GMT

Hi,

You need to use Expression Builder to solve this. I just wrote a blog post for you on it.

alockrem — Mon, 18 Sep 2006 13:14:14 GMT

I know how to use control values in SelectParameters but I don't know how to use user.identity.name as a SelectParameter.

<asp:SqlDataSource

ID="dsAd"

runat="Server"

ConnectionString="<%$ connectionStrings:sampleCnn %>"

SelectCommand="SELECT AD FROM _AdChart WHERE MgrAD=@myAD">

<asp:Parameter Name="myAD" DefaultValue="<%= User.Identity.Name %>" />

</SelectParameters>

</asp:SqlDataSource>

Thanks for any help...