Problem getting Decimal value from Recordset

[jby1]

Hi

I am having an usse retrieving a decimal value from a recordset, and putting it into a C# decimal type.

I am using the following code to do this (recordset is called dr):

decimal decNum = decimal.Parse(dr["decFld"].ToString());

If the decimal number is 10,000,000 or greater, then it causes a parse error. I think this is because from this size of number, it is returned in scientific notation and thus the parse method cannot handle it.

I have worked out that if I use

convert(decimal, decFld)

in the SQL stored procedure, it seems to fix the problem, but I would rather come up with a C# based fix. Any ideas?

 

[jby1]

It is ok, I have sorted it out. Turns out that the database designer had used a real datatype instead of a decimal, which caused the problem. It is now set to be a decimal and working fine!