database

Posted by Shubhashree under ASP.NET on 12/6/2008 | Views : 2523 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

i i am insert a record to database 1 as well as i have to update it in database 2. i have declared connection pooling for both databases . i am struck here how to do next. if any error in bth insert and update transaction has to be rolled back for both please help me out

thank you in advance

regards
shubha

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Jayakumars on: 9/30/2012 [Member] [MVP] Bronze | Points: 25

0	hi which ur face this. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Shubhashree, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Poster on: 12/6/2008 [Member] Starter

0	You can use transaction scope. Create a method to insert and create another method to update. Call both method inside a parent method wrapped with transaction scope. See this article http://www.dotnetfunda.com/articles/article70.aspx Thanks Shubhashree, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts