Capture a sql query after exectuing a store procedure

[Ed Hochberg]

Hi all,

If I execute a sp in sql server 2005 through a C# app which ends with a
simple sql query (selct * from...) is there a way to capture the results into
the app. I am asking because at the moment the results are not put into a
table.

Thanks

 

[Gregory A. Beamer]

If I execute a sp in sql server 2005 through a C# app which ends
with a
simple sql query (selct * from...) is there a way to capture the
results into the app. I am asking because at the moment the results
are not put into a table.

Yes. Use a reader or a Adapter.Fill() just like any other stored procedure
that returns data. Just because a lot of work is being done does not mean
the selected dataset cannot be captured.

Peace and Grace,
Greg

--
Vote for Miranda's Christmas Story
http://tinyurl.com/mirandabelieve

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************