Datareader, there is no data...

[Arjen]

Hello,

How can I check the recordcount?

Here is a little bit of my code:
// Load first row into Datareader
dr.Read();

if (dr["Category"].ToString() == "xmlsrc") {

When I do this I get an error because there is no data... it only have to
check this dr["Category"].ToString() == "xmlsrc") if there is data.
How can I do that?

Thanks!

[Arjen]

When I search for your best practice with google.com I don't find al lot of
material.

[url]http://www.google.nl/search?hl=nl&ie=UTF-8&oe=UTF-8&q=ColumnEnum&lr=[/url]

What namespace do I have to use for ColumnEnum?

Thanks!



"PJ" <pjwalNOSPAM@hotmail.com> schreef in bericht
news:#VjCicnVDHA.2040@TK2MSFTNGP10.phx.gbl...

> the .Read() method returns false if it has reached the end of it's record
> stream so your code should be
>
> if ( dr.Read() )
> {
> //perform actions on row
> }
>
> and...btw, use enums rather than strings to access your columns...it's
> quicker
>
> if ( (string)dr[Convert.ToInt32(ColumnEnum.Category)] == "xmlsrc" )
> //...
>
> "Arjen" <boah123@hotmail.com> wrote in message
> news:bg7ufi$mro$1@news4.tilbu1.nb.home.nl...

> > Hello,
> >
> > How can I check the recordcount?
> >
> > Here is a little bit of my code:
> > // Load first row into Datareader
> > dr.Read();
> >
> > if (dr["Category"].ToString() == "xmlsrc") {
> >
> > When I do this I get an error because there is no data... it only have

to

> > check this dr["Category"].ToString() == "xmlsrc") if there is data.
> > How can I do that?
> >
> > Thanks!
> >
> >

>
>

[PJ]

ColumnEnum was just an example of an enum you would create to access the
columns in your SqlDataReader

enum ColumnEnum
{
Id, Category, etc
}

this way you are accessing the columns by their int index, rather than their
name, which is obviously faster.

"Arjen" <boah123@hotmail.com> wrote in message
news:bg834s$62h$1@news2.tilbu1.nb.home.nl...

> When I search for your best practice with google.com I don't find al lot

of

> material.
>
> [url]http://www.google.nl/search?hl=nl&ie=UTF-8&oe=UTF-8&q=ColumnEnum&lr=[/url]
>
> What namespace do I have to use for ColumnEnum?
>
> Thanks!
>
>
>
> "PJ" <pjwalNOSPAM@hotmail.com> schreef in bericht
> news:#VjCicnVDHA.2040@TK2MSFTNGP10.phx.gbl...

> > the .Read() method returns false if it has reached the end of it's

record

> > stream so your code should be
> >
> > if ( dr.Read() )
> > {
> > //perform actions on row
> > }
> >
> > and...btw, use enums rather than strings to access your columns...it's
> > quicker
> >
> > if ( (string)dr[Convert.ToInt32(ColumnEnum.Category)] == "xmlsrc" )
> > //...
> >
> > "Arjen" <boah123@hotmail.com> wrote in message
> > news:bg7ufi$mro$1@news4.tilbu1.nb.home.nl...

> > > Hello,
> > >
> > > How can I check the recordcount?
> > >
> > > Here is a little bit of my code:
> > > // Load first row into Datareader
> > > dr.Read();
> > >
> > > if (dr["Category"].ToString() == "xmlsrc") {
> > >
> > > When I do this I get an error because there is no data... it only have

> to

> > > check this dr["Category"].ToString() == "xmlsrc") if there is data.
> > > How can I do that?
> > >
> > > Thanks!
> > >
> > >

> >
> >

>
>