Transaction object question

[REB]

If I create a transaction object for rolling back a insert query in the on
click event of a form button can the transaction be tracked across other
functions?

For example:

private void btnSaveDriver_C lick(object sender, System.EventArg s e)

{

Create transaction object

Execute a insert query into a primary table

Call_Funtion_On e(int primary_key_fro m_intial_insert )

Call_Funtion_Tw o(int Primarykey)

on error rollback everything exectued above

}

Call_Funtion_On e(int Primarykey)

{

Execute query to insert data in a related table using key passed into the
function

}

Call_Funtion_Tw o(int Primarykey)

{

Execute query to insert data in a related table using key passed into the
function

}

I hope what I am asking makes sense, if not please let me know and I will
try to elaborate further.

[Harsh Thakur]

Hi,

To track the transaction, you will need to pass a
reference to the transaction object to the functions you
call.

A better way to do it might be like this:

try{
create connection
create transaction

call func1() //performs inserts/updates
call func2() //performs inserts/updates
...
}catch(Exceptio n x){
transaction.Rol lback()
}
transaction.Com mit()

OR
you could inherit your business classes from
ServicedCompone nt and use the COM+ features for
transaction management.

HTH
Regards
Harsh Thakur

-----Original Message-----
If I create a transaction object for rolling back a insert query in the onclick event of a form button can the transaction be tracked across otherfunctions?

For example:

private void btnSaveDriver_C lick(object sender, System.EventArg s e)
{

Create transaction object

Execute a insert query into a primary table

Call_Funtion_O ne(int primary_key_fro m_intial_insert )

Call_Funtion_T wo(int Primarykey)

on error rollback everything exectued above

}

Call_Funtion_O ne(int Primarykey)

{

Execute query to insert data in a related table using key passed into thefunction

}

Call_Funtion_T wo(int Primarykey)

{

Execute query to insert data in a related table using key passed into thefunction

}

I hope what I am asking makes sense, if not please let me know and I willtry to elaborate further.
.