Gridview display and using Session Problem

[ksaw123]

I have used Gridview to that will show a data from the Database, but in the configuration I specify that the WHERE Clause must be SQL Expression Value [Username] = @Username Session("Username") Who can I put the Session value inside this statement (I want to use it hard coded, but I don't know what to write in the page.aspx.cs file? Thanks a lot for your cooperation. Best regards,

[Blue_Boy]

Using Sessions[^]

---

I Love T-SQL

[ksaw123]

Where should I put it? Because I have define it(I used static on for testing) inside Page_Load(.....) { Session["Username"] = "lll"; } But it does not show the Gridview.

[Blue_Boy]

Put it before you bind GridView. Session["Username"]="lll"; . . . GridView1.DataBind();

---

I Love T-SQL

[AlexeiXX3]

If you want to hardcode the parameter in the query, dont use a session parameter, just switch to sourcemode in the form designer (Shift + F7) and find the sql query, and add the where clause Or why are you using a sessionparameter?

Alexei Rodriguez