nanderEire
asked on
How to access results window in Sql Server Management Studio
Hi,
I am working with a plugin for Sql Server Management Studio. After executing a query in SSMS the results are output in a results tab. How would I be able to hook in to get acess to this data programmatically?
Any pointers of either how to do it or where to find the info that might help me are appreciated.
I am working with a plugin for Sql Server Management Studio. After executing a query in SSMS the results are output in a results tab. How would I be able to hook in to get acess to this data programmatically?
Any pointers of either how to do it or where to find the info that might help me are appreciated.
ASKER
I need to be able to compare the results from a query the user enters, to the results we expect them to achieve. Like a tutorial type thing.
Then you can fetch both the results into a data table and can compare it in your application right..
ASKER
I guess so. I'm now thinking a more straightforward way would be to capture the SQL when the user hits execute and re-run the query myself, capturing the results in code.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Why can't you write a simple application to open up a connection to your SQL Server and display the results in a dynamic datatable..
You can't dynamically access the data pro-grammatically like this..