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
no luck, still getting 70 returned :(