Hi all,
I have a customer transaction page. And in this i am doing insert and updates in 7 tables. I wrote below code and sending the data to data base.
btnSubmit_click(object sender, EventArgs e){
insertNewLoan();
updateCustomerThroughLoan();
updatePartyThroughLoan();
insertAccount();
insertCustTransactionbyLoan();
insertPartyTransaction();
insertLoanInstallment();
}
so my query is if any one of the insertion or update is fail, then i need to cancel my previous insert or update statements.
Please help me on this
Thank you.
Loading
Pravin MorePosted Sep 15, 2011, 2:54 AM
you are using seperate functions for your operations on single button click event.....
i recommend u that if possible use same function n call sproc from ur function which will execute all query in sequence.....n then u can apply rollback logic there .......i think like that....
Thanx
Pravin