Problem with decimal type

Question

Hello I have this problem with decimal numbers of a form. When i update the db table the number in the textfield rounds. For example if i enter 24 value after updating the record i get 20. I use sproc with decimal fields for update. (If i enter the value straight to SQL Server table i get the correct value). Any suggestions? Thank you in advance.

naura pax · Answer

hi Another problem that i could think of is in the Stored Procedure you might have not declared parameter with right datatype eg: alter procedure saveInventory @itemid int @quantity int -- it should be decimal(183).

Dealy · Answer

I used Decimal(5) instead of Decimal(51). Thank you for the solution

Kirtan Patel · Answer

Friend  Which Data Type you have used in database ???? for storing those numbers ?? provide the code which you are using to insert the values

naura pax · Answer

If your table has correct datafield type say decimal(182) ( or decimal(18n) where n has some value as per requirement). Then the problem could be in the way you are passing parameter in frontend (or in BLL or DAL layer if you have defined them). At the time of calling stored procedure and adding parameter in ado.net command object code you have to specify data type in that case you might have written Db.Int32 now use Db.Decimal instead if that is the case. hope i'm clear

Saulius · Answer

Hi maby you can try to use float? :) I am not sure