begin and end transaction in two different methods

[shari]

hi guys,

i am new to this asp.net programming, i have some problem
it goes like this:
my requirement is that i have to begin a transaction on one button
click and i have to commit or roll back on different button clicks

is it possible in ado.net

thanks in advance for your replies

 

[John Saunders [MVP]]

hi guys,

i am new to this asp.net programming, i have some problem
it goes like this:
my requirement is that i have to begin a transaction on one button
click and i have to commit or roll back on different button clicks

What if your user home for the night between the first click and the second?

 

[Aidy]

is it possible in ado.net

Yes, but such a bad idea I'm not even going to tell you how If you can
post the problem you're having, maybe we can suggest a better solution.

 

[Mark Rae]

is it possible in ado.net

See the previous replies - this is a *really* bad idea - don't do it...

Transactions should have as short a lifespan as possible, being committed or
rolled back at the first opportunity...