• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

sql server vb .net how to rollback

Hi,
I have a database application, I used sqlconnection, sqldataadapter and dataset. I have all the functions (update,delete,insert) but I want to have a button too to cancel changes eg. when updating and it is wrong or when inserting and want to cancel.
0
kyriakos70
Asked:
kyriakos70
1 Solution
 
openshacCommented:

There's an example here of how to use the commit and rollback of the transaction object:
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21590938.html

Maybe the easiest way for you is to use a BackgroundWorker object.  When you click the "Cancel" button set a flag to true/false;

In the RunWorkerCompleted event of the BackgroundWorker object you want to test the value of the flag and decide to commit or rollback the transaction.

If you need any more info please postback.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now