Decimal defaultValue = 0.00M; >>> IDbDataParameter param1 = this.CreateParameter("@PolicyHeaderPK", policyHeaderFK); >>> IDbDataParameter param2 = this.CreateParameter("@SuspenseAmount", defaultValue); >>> param2.Direction = ParameterDirection.Output; >>> >>> // how do I do this: >>> //param2.Precision = "18,2"; >>> >>> // Call the stored procedure and pass the parameter >>> IDbCommand cmd; >>> this.ExecSprocScalar("PoliciesGetSuspenseAmount", out cmd, param1, param2); >>> >>> // Retrieve the value from the command object >>> IDbDataParameter param = (IDbDataParameter)cmd.Parameters["@SuspenseAmount"]; >>> Decimal suspenseAmount = (Decimal)param.Value;>>
>>Param.Size = 19;
>>Param.Precision = 2
>