Use same sqlTransaction in more webforms ?

[Guest]

Hi,

Maybe this question looks stupid, but could anyone tell me if, and if so
how, it is possible to use the same sqlTransaction in more webpages.

Is it possible to store the sqlTransaction class in a session or viewstate?

It's because I need to create the following structure:

+----------+
| 1 ORDER | ( OrderEntry.aspx)
+----------+
|
+--------------+
| N ARTICLES | (ArticleEntry.aspx?TorId=<orderid>) [ popup ]
+--------------+
|
+----------+
| N TESTS | ( TestEntry.aspx?ArtId=<articleId>) [ popup ]
+----------+

And I want it to be stored in total in the database when the user clicks on
save on the OrderEntry Form.

Therefore I think that I need a transaction which will be committed when the
user clicks save.

Thank you very much,

kind regards,

Chris

 

[Sahil Malik [MVP]]

Spreading one transaction over multiple webforms is a *very* bad idea.


- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/

 

[Mary Chipman [MSFT]]

You don't want to store the transaction, you just want to store the
data until the user finalizes everything. Then you want to create a
transaction that packages up all of the operations involved, connect
to the database, and commit in the least possible time. The basic idea
is to get in and out as quickly as possible and to not hold on to
server or network resources while the user fiddles around trying to
figure out what to do

--Mary

 

[Guest]

Thank you very much...

You don't want to store the transaction, you just want to store the
data until the user finalizes everything. Then you want to create a
transaction that packages up all of the operations involved, connect
to the database, and commit in the least possible time. The basic idea
is to get in and out as quickly as possible and to not hold on to
server or network resources while the user fiddles around trying to
figure out what to do

--Mary

Hi,

Maybe this question looks stupid, but could anyone tell me if, and if so
how, it is possible to use the same sqlTransaction in more webpages.

Is it possible to store the sqlTransaction class in a session or viewstate?

It's because I need to create the following structure:

+----------+
| 1 ORDER | ( OrderEntry.aspx)
+----------+
|
+--------------+
| N ARTICLES | (ArticleEntry.aspx?TorId=<orderid>) [ popup ]
+--------------+
|
+----------+
| N TESTS | ( TestEntry.aspx?ArtId=<articleId>) [ popup ]
+----------+

And I want it to be stored in total in the database when the user clicks on
save on the OrderEntry Form.

Therefore I think that I need a transaction which will be committed when the
user clicks save.

Thank you very much,

kind regards,

Chris