how to use session value during fetching ...

[ruhi]

Hi everyone,

How to use session value during fetching values from database of that particular session value?

SqlDataAdapter adapterprice = new SqlDataAdapter("SELECT product.productid, product.productname, product.price, product.description FROM product where product.productid= Session["productid"] ", myconnection);

During writing code in such a way it is showing error..
Can any one help me in this..??

[Ramy Mahrous]

You should write it like

SqlCommand selectCommand = new SqlCommand("SELECT product.productid, product.productname, product.price, product.description FROM product where product.productid = @productID", myConnection);

            selectCommand.Parameters.Add("@productID", SqlDbType.Int);

            selectCommand.Parameters[0].Value = int.Parse(Session["productid"].ToString());

            SqlDataAdapter adapterprice = new SqlDataAdapter(selectCommand);

[ruhi]

Thank you very much...