SelectParameters

Home ›

ASP.NET Forums » General ASP.NET » Data Presentation Controls » SelectParameters

Shortcuts

Previous Next

Last post 03-31-2007 10:09 AM by carrics3. 4 replies.

Sort Posts:

SelectParameters

09-18-2006, 9:14 AM

Contact

206 point Member
alockrem
Member since 09-06-2006, 4:57 PM
Orlando, FL
Posts 197

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...

Re: SelectParameters

09-18-2006, 1:03 PM

Contact

Answer

23,803 point All-Star
pkellner
Member since 11-12-2004, 10:42 AM
San Jose, California
Posts 3,567

Hi,

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

http://peterkellner.net/2006/09/18/expressionbuilderidentity/

Peter Kellner
http://peterkellner.net
Microsoft MVP • ASPInsider

Re: SelectParameters

09-19-2006, 9:56 AM

Contact

206 point Member
alockrem
Member since 09-06-2006, 4:57 PM
Orlando, FL
Posts 197

Great! I appreciate your help.

Re: SelectParameters

03-30-2007, 5:00 AM

Contact

19 point Member
bitflusher
Member since 10-13-2006, 9:30 PM
Posts 11

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>

Re: SelectParameters

03-31-2007, 10:09 AM

Contact

7 point Member
carrics3
Member since 03-09-2007, 10:35 AM
Posts 57

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?

Page 1 of 1 (5 items)

RSS Available