From: Raj on
Any ideas about using single transaction across pages of an application?

Thank you

Regards
Raj
From: Andy O'Neill on

"Raj" <Raj(a)discussions.microsoft.com> wrote in message
news:C9A5960D-0181-47D5-A3DE-8F6D342427D7(a)microsoft.com...
> Any ideas about using single transaction across pages of an application?
>
> Thank you
>
> Regards
> Raj

Yes.
Do them as logic transactions rather than database transactions.
IE hold your data in memory in a collection of some sort - a list or two
lists or a dataset.
Then write them to the database in one go.
Holding a database transaction open across pages is a big NO on database
systems.