Hello I am tring to insert a rwo with a decimal value. All the numbers after the decimal end in 0's though.

cmdQry.Parameters.Add(new SqlParameter("@Size", SqlDbType.Decimal));
cmdQry.Parameters[cmdQry.Parameters.Count - 1].Value = Convert.ToDecimal(this.thesize);

where thesize is instantiated as a float.

i want the row to have a value of 14.67888, but it stores it as 14.00000

the column's data type in Sql server is decimal(18,5).

Any ideas of what is causing this?

Nevermind I feel like an idiot, I didn't have decimal type set in my SPROC.