problem withsqltransaction

[John]

i need advice to my problems as follow:

i need to update 3 table (say table a, table b and table c) using
sqltransaction (because i want all transaction either commit or rollback).
table c will be updated after table a and table b updated.
the problem is:
table c can not updated because of sqltransaction didn't update (commit) the
table a and b yet .
any idea how to solve this problem?

 

[Armin Zingler]

i need advice to my problems as follow:

i need to update 3 table (say table a, table b and table c) using
sqltransaction (because i want all transaction either commit or
rollback). table c will be updated after table a and table b
updated.
the problem is:
table c can not updated because of sqltransaction didn't update
(commit) the table a and b yet .
any idea how to solve this problem?

As the question is not VB.Net language specific, have a look at the ADO.Net
group: microsoft.public.dotnet.framework.adonet


Armin