"Arvind P Rangan" <arvind99@hotmail.com> wrote in message
news:022601c3a9b4$20455d10$a001280a@phx.gbl...
> Hi All,
>
> How do you get all the values of a sqldatareader if it
> contains multiple resultset.
> Using sqldatareader.nextresult and sqldatareader.read
>
> e.g.
> While sqldatareader.read '
> If not sqldatareader then
> sqldatareader.nextresult
> else
> ---do something
> end if
> while end
>
> I get the values but due to two sqldatareader.read one
> more record is skiped how do i avoid it.
>
> Thanks
> Arvind.
>