pythonV
asked on
How do I call a session variable into a Table adapter SQL query using Query builder
Hello,
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Just realised that a new change in the query resulted in not getting any fields returned.
I need to rethink the query but in terms of passing the parameters all is well.
Thanks for your help.
I need to rethink the query but in terms of passing the parameters all is well.
Thanks for your help.
ASKER
I am databinding to a gridview, for some reason the gridview is not appearing on the page.
Any ideas?
Thanks for your help.