Passing a query string to a table adapter
In a stored procedure, you can pass a query string and just execute it...
Exec(@SqlCommand)
When creating a table adapter query, is there a way to run a query string you pass in?
Thanks.
Exec(@SqlCommand)
When creating a table adapter query, is there a way to run a query string you pass in?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How do I use this? What am I missing?
It errors that the Declare Sql Construct or statement is not supported.
It errors that the Declare Sql Construct or statement is not supported.
ASKER
I'd like to pass in my querystring, so I've also tried this:
exec sp_executesql @SQLString
Errors exec statement isn't supported.
How do I get this to work?
thanks.
exec sp_executesql @SQLString
Errors exec statement isn't supported.
How do I get this to work?
thanks.
ASKER
well, I never got an answer on how to implement this. But I'm going to close it out.
ASKER
It errors that the Declare Sql Construct or statement is not supported.