oracle number field and datareader

[Mike]

How do I select a number field from oracle 9i? The field is a
number(integer). I have this line in my datareader:

double dbid;
dbid = dr.GetDecimal(0);

I have tried getstring, convert and other things but come up with various
exceptions.

Any help is greatly appreciated! I am stuck here over what should be very
simple.

Thanks
Mike

[W.G. Ryan MVP]

Mike - you can use the GetValue in a pinch but I believe the GetInt32 is the
correct translation.

What exceptions are you getting? This is key in knowing what the problem is
b/c if the values are Null in the db - then you can't use Getxxx without
first checking for Is DBNull - this is a common source of problems like this
"Mike" <Mi**@discussions.microsoft.com> wrote in message
news:E6**********************************@microsof t.com...

How do I select a number field from oracle 9i? The field is a
number(integer). I have this line in my datareader:

double dbid;
dbid = dr.GetDecimal(0);

I have tried getstring, convert and other things but come up with various
exceptions.

Any help is greatly appreciated! I am stuck here over what should be very
simple.

Thanks
Mike

[Mike]

The GetInt32 did it! Thanks. I guess I hadn't tried that one.

Mike

"W.G. Ryan MVP" wrote:

Mike - you can use the GetValue in a pinch but I believe the GetInt32 is the
correct translation.

What exceptions are you getting? This is key in knowing what the problem is
b/c if the values are Null in the db - then you can't use Getxxx without
first checking for Is DBNull - this is a common source of problems like this
"Mike" <Mi**@discussions.microsoft.com> wrote in message
news:E6**********************************@microsof t.com...

How do I select a number field from oracle 9i? The field is a
number(integer). I have this line in my datareader:

double dbid;
dbid = dr.GetDecimal(0);

I have tried getstring, convert and other things but come up with various
exceptions.

Any help is greatly appreciated! I am stuck here over what should be very
simple.

Thanks
Mike