oracle number field and datareader

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 - 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
 
Back
Top