Cannot return full decimal from sql parameters

[MJV57]

I have a line of code as follows:
totalhoursTextBox.Text = (Convert.ToString(cmd.Parameters["@totalhrs"].Value.ToString()));

This code always truncates the digits after the decimal. Can anyone help with what is required to change to get the digits after the decimal. Eg. Now I get 41 when I should get 41.3.

 

[jmeckley]

Convert.ToString(cmd.Parameters["@totalhrs"].Value.ToString())

is redundant.

cmd.Parameters["@totalhrs"].Value.ToString();

will get the string value for you (assuming it's never null);

as for the conversion problem. this code isn't causing the rounding issue. it's most likely the sql statement that's causing the rounding. to confirm this

var value = cmd.Parameters["@totalhrs"].Value

then use the debugger to view the value assigned to [tt]value[/tt]. it will be 41.

if you are performing mathematical operations between different data types (for example an integer and a decimal) the data type with less precision will be used for the result. integer has less precision than decimal. to compensate for this convert the integer to a decimal and then preform the calculation.

select @totalhrs = convert(decimal(5,2), integer_field) / decimal_field

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
faq732-7259

 

[MJV57]

I have checked the sql out put and it does give out numbers after the decimal.

 

[SimonSellick]

Not wanting to seem impertinent, but what is the data type of the parameter?

 

[MJV57]

Decimal

 

[litton1]

Using this code, what does the MessageBox show?

if(cmd.Parameters["@totalhrs"].Value != DBNULL.Value)
{
   object oDec = cmd.Parameters["@totalhrs"].Value;
   decimal dec = decimal.Parse(oDec.ToString());
   MessageBox.Show(dec.ToString("G"));
}
else 
{
   MessageBox.Show("It was NULL!!"));
}

Age is a consequence of experience