Use same sqlTransaction in more webforms ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Thank you very much... :)

Mary Chipman said:
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
Click to expand...
Click to expand...
 
Back
Top