Quote:
string str = "insert into LoanMaster( custId, principal,LoanTerm
,LoanInterest,LoanMaturedAmt,LoanRate, Loanloantype, Loanmonthlyp) ";
str += " values (@custId, @principal,@LoanInterest,@LoanMaturedAmt,@LoanRate,@Loanloantype,@Loanmonthlyp,@LoanTerm
)";
int the insert statement, you are passing
@Loadloantype
value to
LoanRate
column
where
@Loadloantype
holds the
string
value and
LoadRate
is of type
decimal
use this
string str = "insert into LoanMaster( custId, principal,LoanTerm,LoanInterest,LoanMaturedAmt,LoanRate, Loanloantype, Loanmonthlyp) ";
str += " values (@custId, @principal,@LoanTerm,@LoanInterest,@LoanMaturedAmt,@LoanRate,@Loanloantype,@Loanmonthlyp)";