|
|
|
|
08-09-2005, 10:03 AM
|
#1 |
Transactions
Hi All,
Can any one tell me how would you do nested transaction in Ado.net. My situation is I have opened a transaction i have five records in a grid- 1 2 3 4 5 When i pass 1 it should be in a transaction, If it succeeds or failed , it should start with the next record THanks in Advance thomson thomson |
|
|
|
08-09-2005, 10:44 AM
|
#2 |
|
Posts: n/a
|
Re: Transactions
Begin the transaction
Wrap all you updates/processing into a try statement. Place the rollback in the Catch Statement If an exception occurs the transaction is rolled back, or if a criteria you have specified is not met,you simply throw an exception If there is no exception, you commit the transaction So within the Try statement, you just place your updates one after the other Does that answer your question? "thomson" <> wrote in message news: oups.com... > Hi All, > Can any one tell me how would you do nested transaction in > Ado.net. > My situation is > > I have opened a transaction > > i have five records in a grid- > > 1 > 2 > 3 > 4 > 5 > > When i pass 1 it should be in a transaction, If it succeeds or failed , > it should start with the next record > > THanks in Advance > > > > thomson > Grant Merwitz |
|
|
 |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Importance of SSL Certificates | jenny | Software | 0 | 11-20-2006 07:11 AM |
| Get SSL Certificates for your Site | falcon11 | Software | 0 | 11-18-2006 07:17 AM |
| email I just sent to Deep Discount DVD | FAQmeister | DVD Video | 20 | 07-24-2004 06:34 AM |
