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

SelectParameters

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

Sort Posts:

  • SelectParameters

    09-18-2006, 9:14 AM
    • Loading...
    • alockrem
    • Joined on 09-06-2006, 4:57 PM
    • Orlando, FL
    • Posts 164

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

    <SelectParameters>

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

    </SelectParameters>

    </asp:SqlDataSource>

     Thanks for any help...

  • Re: SelectParameters

    09-18-2006, 1:03 PM
    Answer
    • Loading...
    • pkellner
    • Joined on 11-12-2004, 10:42 AM
    • San Jose, California
    • Posts 3,379
    • Moderator
      TrustedFriends-MVPs

    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://73rdstreet.com and blogging at
    http://PeterKellner.net
    MVP, ASP.NET

  • Re: SelectParameters

    09-19-2006, 9:56 AM
    • Loading...
    • alockrem
    • Joined on 09-06-2006, 4:57 PM
    • Orlando, FL
    • Posts 164
    Great!  I appreciate your help.

  • Re: SelectParameters

    03-30-2007, 5:00 AM
    • Loading...
    • bitflusher
    • Joined on 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

     

    <SelectParameters>

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

    </SelectParameters>

  • Re: SelectParameters

    03-31-2007, 10:09 AM
    • Loading...
    • carrics3
    • Joined on 03-09-2007, 10:35 AM
    • Posts 57

    Hi

     

    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

Advertise on ASP.NET

About this Site

Microsoft Communities
Page view counter