DataSet truncates decimal points to 2 digits

Question

I have a SQL Server stored procedure that returns a column named "LienAlloc_Amt" of type money. In SQL Server Management Studio (SSMS), a record returns "LienAlloc_Amt" value of "85.226" (3 decimals). But when I retrieve the value from C# code using DataSet, only "85.22" is set.

Why is "LienAlloc_Amt" is truncated when the dataSet object is filled?

Answer 1

check what is the return type of your procedure, side of application. maybe you cast this type into class, so this may cause problem.Try auto generated type.