SQLServer transactions? 1

[DeltaTech]

Hi

Can anyone help with SQL server transactions please?

I have a number of updates to perform and want to commit the transactions only if all are successful.

With ADO, all that was needed were ADO BeginTrans, CommitTrans and RollbackTrans Methods. Have searched the web, but nothing really elaborate turned up.

A little help with how to construct the code would be very much appreciated.

Thanks

 

[DeltaTech]

Sorry, forgot to mention that I am doing this in ASP.Net.

Thanks

 

[markros]

Just write it as a stored procedure and use BEGIN TRANSACTION END TRANSACTION syntax. See BOL for details.

 

[markros]

I just found an interesting article that may serve as an example for your case as well

http://www.sql-server-performance.com/articles/per/deadlock_sql_2005_p2.aspx

 

[DeltaTech]

Hi markros

Thank you for your prompt reply.

Quote: "See BOL for details"

Sorry, could you clarify/elaborate please?

Thanks

 

[RyanEK]

Hi,

This is more of an ASP.Net question. However, if you've established a connection using SqlConnection(), you can create an instance of a SqlTransaction(). This class has the methods BeginTransaction(), Rollback() and Commit().

For typical usage there are plenty of resources online.

Ryan

 

[DeltaTech]

Hi Ryan

Appreciate the feedback.

Yes it is an ASP.Net/VB.Net question, and you are right, I establishing a SqlConnection.

I have searched online, but could not find anything that explained the SqlTransaction process in simple enough terms. (Sorry mate, I am a beginner and sometimes find it a bit hard to filter through the techno babble.)

You said there are plenty of resources online. Could you point me to a few or perhaps help me with some sample code?

 

[RyanEK]

Here is an example as provided by MS SqlConnection.BeginTransaction Method

Ryan

 

[DeltaTech]

Hi Ryan

The example you gave is what I was looking for.

Thanks very much