Greetings, all.
I have a stored procedure that uses a temporary table. Although I can create it fine within Visual Studio and attach it to a Data Source, when I try to connect it to a Gridview, I get no results.
And when I try to refresh the schema, to see the results, I get this:
"unable to retrieve schema. Ensure that the ConnectionString and SelectCommand properties are valid.
Invalid object name '#temp'.
Any suggestions?
Thanks in advance!
...
Go to the complete details ...