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?
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.