decimal data type all 0's after decimal
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?