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

=?Utf-8?B?RWQgSG9jaGJlcmc=?= <EdHochberg@discussions.microsoft.com>
wrote in news:24A898C3-98F1-4832-92D5-64C5BBF57837@microsoft.com: 

>   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!             |
*******************************************