Using RollBack Transactions in VB.NET [Resolved]

Posted by Sankar20092010 under ADO.NET on 12/3/2013 | Points: 10 | Views : 2659 | Status : [Member] | Replies : 3
Hi..

Is there a method for using rollback transactions in VB.NET. In my application i am using 1 sql statement and 1 stored procedure first for deleting the entire table and then inserting the grid details using insert stored procedure.

My problem is when first sql statement is executed and some problem occured then the table is deleted and insertion also will not be done. So i need to use transactions in .NET , any one have solutuon please reply asap.

I am using database layer also, since it is vb
Thanks and Regards

Sankar
Cochin




Responses

Posted by: vishalneeraj-24503 on: 12/3/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Please refer:-
http://www.codeproject.com/Articles/522039/A-Beginners-Tutorial-for-Understanding-Transaction
http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope%28v=vs.110%29.aspx
http://msdn.microsoft.com/en-us/library/2k2hy99x%28v=vs.110%29.aspx
http://stackoverflow.com/questions/4456301/how-to-check-if-dotnet-transaction-is-rolled-back

Sankar20092010, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: vishalneeraj-24503 on: 12/3/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Also refer:-
http://stackoverflow.com/questions/224689/transactions-in-net
http://www.knowdotnet.com/articles/transactions.html
http://community.actian.com/wiki/DOT_NET_Examples_-_EnlistTransaction_TransactionScope

Sankar20092010, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response