How do I call a session variable into a Table adapter SQL query using Query builder
Posted on 2008-10-07
I am using ASP.NET with VB and i need to create a gridview which gets data from an SQL query.
For the WHERE condition of the query i need to call a global variable ex. Session("item"), how do i do this using the query builder when creating a new table adapter. I would rather not do it by code.
Any help is appreciated,
Thanks in advance.