ALawrence007
asked on
Begin Transaction SQL insert in VB Winforms
Hi,
I have a winforms application that inserts Items into my Database. I want to insert the items using the "Begin Transaction" SQL Statement and when it is finished with NO errors I want to commit the transaction to the database. If there were errors in the Transaction, I want to Roll back my Transaction.
Would this be good practice? If so, does anyone have some sample VB code that I can modify?
Thanks for the help.
I have a winforms application that inserts Items into my Database. I want to insert the items using the "Begin Transaction" SQL Statement and when it is finished with NO errors I want to commit the transaction to the database. If there were errors in the Transaction, I want to Roll back my Transaction.
Would this be good practice? If so, does anyone have some sample VB code that I can modify?
Thanks for the help.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ya sure
you can mail to me ankjindal@yahoo.co.in
you can mail to me ankjindal@yahoo.co.in
ASKER
This answer helped me in this situation.
jindalankush,
Helped me in other sections of my project.