CODEWITHSUNDEEP
c#asp.netdatagridview
NewPassionnate
NewPassionnate

Reputation: 179

SqlDataSource : adding user session in parameters

I am using a datagridview with edit and delete auto generated.

I would like to use in my select statement my session user as a parameter.

When I do that, it doesn't display anything. 

SelectCommand="SELECT DISTINCT .... WHERE AgentID = @UserID">

<SelectParameters>
    <asp:Parameter Name ="Session['UserID']"></asp:Parameter>
</SelectParameters>

How I declare my session: I tried it and it's working well. 

   Session["UserID"] = (int)cmd.ExecuteScalar();

Upvotes: 0

Views: 108

Answers (1)

Sepehr Kazemi
Sepehr Kazemi

Reputation: 150

You can use asp sessions parameter:

<asp:SessionParameter Name="randomname" Type="string" SessionField="UserID" DefaultValue="your default value"/>

Upvotes: 1

Related Questions