Re: Please comment!

I think the model breaks down with a data reader however, since you can't
/easily/ do the databinding because the data reader requires the first
result set to be closed before moving to the next result set.

Adam..

> -----Original Message-----
> From: Discussion of building .NET applications targeted for
> the Web [mailto:DOTNET-WEB@xxxxxxxxxxxxxxxxxxx] On Behalf Of
> Mark Kucera
> Sent: Friday, June 24, 2005 9:04 AM
> To: DOTNET-WEB@xxxxxxxxxxxxxxxxxxx
> Subject: Re: [DOTNET-WEB] Please comment!
>
> Its pretty simple, you just add additional select queries to
> your stored procedure
>
> CREATE PROCEDURE [dbo].[sptest] AS
> select * from users
> select * from employees
> GO
>
> This will return 2 resultsets.
>
> If you use a SqlDataReader then you can iterate through the
> results sets using the datareader.NextResult() method, or
> with a dataset, you can iterate through the Tables[] collection.

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com