System.Web.HttpContext.Current.User.Identity.Name as SqlDataSource property

Question

  <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
      ConnectionString="<%$ ConnectionStrings:FlowServerConnectionString %>" 
      SelectCommand="SELECT [RepGroup_Name], [RepGroup_ID] FROM [Rep_Group] WHERE [RepGroup_ID] in
            (SELECT [ID_RepGroup]
            FROM [FlowServer].[dbo].[Rep_Permission]
            WHERE [ID_User]=@ID_User)">
      <SelectParameters>
          <asp:ProfileParameter DefaultValue="" Name="ID_User" PropertyName="UserName" />
      </SelectParameters>

How to insert System.Web.HttpContext.Current.User.Identity.Name to my property "ID_User" (it's username here)

300 baud · Accepted Answer · 2010-03-11 16:10:09Z

2

On your SqlDataSource1 add OnInit="SqlDataSource1_Init" then add the following event to the code behind:

protected void SqlDataSource1_Init(object sender, EventArgs e)
{
    this.SqlDataSource1.SelectParameters["ID_User"].DefaultValue = System.Web.HttpContext.Current.User.Identity.Name;
}

answered Mar 11, 2010 at 16:10

300 baud

1,6721 gold badge12 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

System.Web.HttpContext.Current.User.Identity.Name as SqlDataSource property

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related