Problem in Sql Transaction

Question

0.00/5 (No votes)

See more:

Hello There

I have a C# application in which I am using SQL transaction.
At a point if we make changes in a table (after begin transaction) and again reuse of same table then the system not allow to make changes and it stops working.
So I want to know is there any alternate solution available to do the same because I can't even fetch the data from that table.

Need Suggestion
Best Regards

Posted 11-Jan-13 23:12pm

Mayank Topiwala

Add a Solution

Comments

OriginalGriff 12-Jan-13 5:28am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Perhaps if you show us the relevant code fragment you are using to do this?
Use the "Improve question" widget to edit your question and provide better information.

Mayank Topiwala 12-Jan-13 5:34am

Let's Say a Transaction Processing System starts with :
Insert into DaysMaster Values (.....)
And now I need some data from DaysMaster
Select * From DaysMaster Where Days ='...'
So the problem is I can't fetch data from DaysMaster.

2 solutions

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)

Wendelius · Answer 1 · 2013-01-11T23:28:00

Solution 1

Based on the description, it sounds like you're having either a lock collision or even a deadlock.

Try investigating from SSMS what the halted session is waiting for. For this you can use either activity monitor or query sys.dm_tran_locks[^]

Posted 11-Jan-13 23:28pm

Wendelius

Vishal.Shimpi144 · Answer 2 · 2013-01-12T00:46:00

Solution 2

i thing First you are inserting data in table and then fetch the same data from table and u r using transaction, means before committing you are trying to fetch data, so try to commit first the the fetch data

Posted 12-Jan-13 0:46am

Vishal.Shimpi144

Comments

Mayank Topiwala 12-Jan-13 23:43pm

Yes Vishal I know this thing and that's my problem.I don't want to fetch the updated data; I just want to fetch the previous records.
Like in Access database we can select the record from a table even if that table in the process of transaction.