how to use insert and delete query within begin transaction and commit in c #

Question

1.00/5 (2 votes)

See more:

SQL-Server-2008R2

I want to use two func within between begin transaction and commit transaction as shown below

C#

try
{
Begin transaction()
Delete();
Insert();
Commit()
}
Catch() ..

Problem is when breakpoint reaches delete function and try execute some delete query on SQL enterprise 2008 then it hangs there or get locked. I am unable figure out the reason.can anyone help.

Posted 29-Jun-15 8:51am

sunshine@work.

Updated 29-Jun-15 9:11am

Suvendu Shekhar Giri

v2

Add a Solution

Comments

Suvendu Shekhar Giri 29-Jun-15 15:15pm

"Begin Transaction()" method name with white space? Can you share what is written in these 4 methods- BeginTransaction(),Delete(),Insert() & Commit() ?

[no name] 29-Jun-15 15:57pm

No, probably not. We would have no idea at all what your functions do. Learn how to run your code in the debugger and find out what is going on in your code.

sunshine@work. 29-Jun-15 16:02pm

I know how to debug. I just want to know the reason for locking of the table while deleting rows. Thanks anyways.

[no name] 29-Jun-15 16:15pm

Apparently you do not. How would you expect us to tell you anything without seeing your code?

sunshine@work. 29-Jun-15 23:54pm

Apparently code project does not seem to be useful , I guess for my problem

[no name] 30-Jun-15 9:21am

No one at code project, or anywhere else, can see your code, look over your shoulder and debug your code for you. Debugging your code is your responsibility not ours. No sure why you think that we would automagically know what your delete method is doing without showing us or even describing an actual problem.

sunshine@work. 30-Jun-15 11:05am

Am not asking for any volunteers who can debug on my behalf.I know I have to do it.I just wanted to know about BEGIN TRANSACTION and COMMIT .

[no name] 30-Jun-15 11:15am

Okay so what? Go read the documentation!

sunshine@work. 30-Jun-15 12:04pm

Haha ..
Thnx for valuable sugestion.

1 solution

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)

sunshine@work. · Accepted Answer · 2015-06-29T09:35:00

Sir basically problem comes after BeginTransaction(). When the breakpoint goes into Delete function.
In this delete function ,we are deleting few rows from table .
This delete function returns int. Value.

For ex

Int val = delete();
If ( val == -1)

My problem is when delete is called , after the breakpoint does not come on if condition.