[RESOLVED] How can you use a Session variable in a Query?

My Problem is that I want to use a Session variable in a Page,using SQLDatasource and Gridview, but my gridview is not populating necessery data which means the the variable is not initialized as input in the SQLDATASource control or gridview, just want
to know in which event can it successfully initialize data.The SQLDatasource I am using is populating correct data when i test the query in sqldatasource control.So Here's the code:-

CODE

string str;

str = Session["Username"].ToString();

MARKUP of SQLDataSource

            ConnectionString="<%$ ConnectionStrings:BookStoreConnectionString %>"


            DeleteCommand="DELETE FROM [ShoppingCart] WHERE [OrderID] = @OrderID"


            

            SelectCommand="SELECT ShoppingCart.orderid, ShoppingCart.bookid, ShoppingCart.bookname, BookDetails.cover, ShoppingCart.quantity, ShoppingCart.price, ShoppingCart.totalprice, ShoppingCart.billnumber, ShoppingCart.payment, ShoppingCart.member FROM
BookDetails INNER JOIN ShoppingCart ON BookDetails.bookid = ShoppingCart.bookid WHERE (ShoppingCart.member = @usr) AND (ShoppingCart.payment = '')"


            onfiltering="SqlDataSource1_Filtering"

            ondisposed="SqlDataSource1_Disposed" oninit="SqlDataSource1_Init"

            oninserted="SqlDataSource1_Inserted" oninserting="SqlDataSource1_Inserting"


            onload="SqlDataSource1_Load" onprerender="SqlDataSource1_PreRender"

            onselected="SqlDataSource1_Selected" onselecting="SqlDataSource1_Selecting">

           

               

           

           

               

           

       

Please Suggest..

Maybe you can directly using session parameter

Refer this

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sessionparameter.sessionfield.aspx

http://dotnetcommanche.blogspot.in/2011/06/passing-session-parameter-into.html

You can use sessionparameter, refer following:

http://forums.asp.net/t/1062765.aspx