-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Neeraj_Bangalore
Message 12 in Discussion
Hi
Dinesh,
As I
said earlier, data/transaction once commited is comitted, you cannot do
anything to it, by RollBack mechanism.
One
way ( Dirty Fix ) could be - on failure of second transaction who execute the
code,manually, to nullify the the effect of first transaction. As you said, you
are returning some value back in class1 which you have to use further in class2,
if that itself can be used to identify the changes that transaction of class1
has done then it is fine else return the necessary values and use them on
failure of second transaction to nullify the effect of first
transaction. Also, return the success/failure status from the class2 so
that you can write code to rollback the effect of transaction of
class1.
Something Like this
Private Sub MyMethod
Dim obj1 as Class1
-- Do things for CLass1
x = ReturnSomeValue
Dim obj2 as Class2
--- DO things for class2
y = SuccessStatusFromClass2
if ( y does not indicates success ) then
Manual Code for RollBack of Class1
transaction using x.
End Sub
Regards,
Neeraj Saluja
SCT Software Solutions,
Bangalore
-----Original Message-----
From: dinesh_gr
[mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 1:27
PM
To: BDOTNET
Subject: Re: Handling Transactions in
ADO.net
New Message on BDOTNET
Handling
Transactions in ADO.net
Reply
Reply to Sender Recommend
Message 10 in
Discussion
From: dinesh_gr
HI Neeraj,
I am instantiating the Class2 object inside
Class1....
Instead the code goes likes this....
Test.aspx.vb....
Private sub Button_Click()
Try
Dim x as new Class1()
-- Try, ctach is present for Class1
The Class 1 does some DB operations and
gives an output...
again, here i nstatiate the Class2..
ie.. Dim Y as new class2() -- Try and Catch is
also present for this Class2..
catch objEx as exception
end try...
end sub
This is how my code goes...
Noe if any error happens in Class2... Hoe do i roll back
all the operations happened in Class1....Provided Class1 and
Class2 has all the Transactions handled....
Regards,
Dinesh.
View other groups in this
category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
