SqlDataReader problem

[Arjen]

Hello,

With my SqlDataReader I select 2 records.

Here is a little bit of my code:
SqlDataReader dr = documents.GetDocuments(ModuleId);

// Load first row into Datareader
if (dr.Read()) {
// Read it!
}

// Load second row into Datareader
if (dr.NextResult()) {
// Read it!
}

dr.Close();

The problem is that the second record dr.NextResult() doesn't work. But
there are two records selected!!!

Why is it not working?

Thanks!

[Marina]

If the 2 records are both as a result of one query, then you just need to
call Read again to advance to the next row.

If they are in different record sets, then you need to call Read after
calling NextResult, to advance the next result set to the first row.

"Arjen" <boah123@hotmail.com> wrote in message
news:bg8uq7$eip$1@news4.tilbu1.nb.home.nl...

> Hello,
>
> With my SqlDataReader I select 2 records.
>
> Here is a little bit of my code:
> SqlDataReader dr = documents.GetDocuments(ModuleId);
>
> // Load first row into Datareader
> if (dr.Read()) {
> // Read it!
> }
>
> // Load second row into Datareader
> if (dr.NextResult()) {
> // Read it!
> }
>
> dr.Close();
>
> The problem is that the second record dr.NextResult() doesn't work. But
> there are two records selected!!!
>
> Why is it not working?
>
> Thanks!
>
>

[MS News]

call dr.Read() again and not dr.NextResult()

You don't have multiple Select in your Query??


"Arjen" <boah123@hotmail.com> wrote in message
news:bg8uq7$eip$1@news4.tilbu1.nb.home.nl...

> Hello,
>
> With my SqlDataReader I select 2 records.
>
> Here is a little bit of my code:
> SqlDataReader dr = documents.GetDocuments(ModuleId);
>
> // Load first row into Datareader
> if (dr.Read()) {
> // Read it!
> }
>
> // Load second row into Datareader
> if (dr.NextResult()) {
> // Read it!
> }
>
> dr.Close();
>
> The problem is that the second record dr.NextResult() doesn't work. But
> there are two records selected!!!
>
> Why is it not working?
>
> Thanks!
>
>

[Arjen]

Nope, I understand.



"MS News" <sql_agentman@hotmail.com> schreef in bericht
news:eKlxyNsVDHA.3088@tk2msftngp13.phx.gbl...

> call dr.Read() again and not dr.NextResult()
>
> You don't have multiple Select in your Query??
>
>
> "Arjen" <boah123@hotmail.com> wrote in message
> news:bg8uq7$eip$1@news4.tilbu1.nb.home.nl...

> > Hello,
> >
> > With my SqlDataReader I select 2 records.
> >
> > Here is a little bit of my code:
> > SqlDataReader dr = documents.GetDocuments(ModuleId);
> >
> > // Load first row into Datareader
> > if (dr.Read()) {
> > // Read it!
> > }
> >
> > // Load second row into Datareader
> > if (dr.NextResult()) {
> > // Read it!
> > }
> >
> > dr.Close();
> >
> > The problem is that the second record dr.NextResult() doesn't work. But
> > there are two records selected!!!
> >
> > Why is it not working?
> >
> > Thanks!
> >
> >

>
>