How do i check whether a Transaction is in Progress in C#?

Question

0.00/5 (No votes)

See more:

How do I check whether a Transaction is in Progress in C#?

If so then the next transaction should be executed after the previous one is completed.

Thanks in Advance.

Posted 19-Oct-11 21:27pm

Deepak.xip

Updated 19-Oct-11 22:18pm

Dalek Dave

v2

Add a Solution

Comments

Dalek Dave 20-Oct-11 4:18am

Edited for Readability.

4 solutions

Solution 3

Check this link
Implementing an Implicit Transaction using Transaction Scope

Posted 19-Oct-11 21:34pm

sachin10d

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Uday P.Singh · Accepted Answer · 2011-10-19T21:31:00

Solution 1

If you are using System.Data.SqlClient.SqlTransaction it will take care of these issues for you. Try these for Using Transaction:

Using Transactions in ADO.NET[^]

http://www.c-sharpcorner.com/UploadFile/dchoksi/transaction02132007020042AM/transaction.aspx[^]

hope it helps :)

Posted 19-Oct-11 21:31pm

Uday P.Singh

Comments

Mehdi Gholam 20-Oct-11 3:32am

My 5!

Uday P.Singh 20-Oct-11 3:35am

Thanks Mehdi :)

RaviRanjanKr 20-Oct-11 3:45am

Nice Link, My 5+

Uday P.Singh 20-Oct-11 3:56am

thanks Ravi :)

Dalek Dave 20-Oct-11 4:18am

Excellent Answer.

Uday P.Singh 20-Oct-11 5:46am

thanks Dave :)

Mehdi Gholam · Accepted Answer · 2011-10-19T21:32:00

Solution 2

You don't need to check the transaction status in your code, just create your transactions and the DB server will handle them.

It will kill your performance if you wait for each transaction to finish before starting a new one in your code.

There are things you should be aware of when using transactions like locked pages etc.

Read the following on transaction isolation levels : http://msdn.microsoft.com/en-us/library/ms173763.aspx[^]

Posted 19-Oct-11 21:32pm

Mehdi Gholam

Comments

Uday P.Singh 20-Oct-11 3:35am

good point with nice link 5+ :)

RaviRanjanKr 20-Oct-11 3:45am

Nice answer, My 5+

Dalek Dave 20-Oct-11 4:18am

True, +5

Mehdi Gholam 20-Oct-11 4:57am

Thanks

RaviRanjanKr · Accepted Answer · 2011-10-19T21:41:00

Solution 4

In addition to Uday and Mehdi answer I suggest you to navigate given Stackoverflow link for getting some usefull answer in regarding to your requirement.
Read Solution[^]
then you can read MSDN-[Using the TransactionScope Class][^]

Posted 19-Oct-11 21:41pm

RaviRanjanKr

Comments

Mehdi Gholam 20-Oct-11 3:57am

Cheers 5!

RaviRanjanKr 20-Oct-11 4:00am

Thanks :)

Uday P.Singh 20-Oct-11 3:59am

nice! now the OP have all the stuffs required to work on transactions. Team effort 5+ :)

RaviRanjanKr 20-Oct-11 4:00am

Thanks :)