problem withsqltransaction

8 Mar 2006 3:44 AM

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?

8 Mar 2006 10:31 AM

Armin Zingler

"John" <J***@yahoo.com> schrieb
> 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