Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
0
Reply
Need help in Transactionscope
Ravi Shekhar
Dec 12 2013 4:19 AM
1k
Reply
I am using Transactionscope for transaction. In this transaction... I used two databases Oracle and Sql server.
1st - Get data from Sql server
2nd - Upload sql data on oracle server
3rd - Now update flag on sql server of uploaded data
above task done on the button click
var transactionOptions = new TransactionOptions();
transactionOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted;
transactionOptions.Timeout = TransactionManager.MaximumTimeout;
using (TransactionScope DispTran = new TransactionScope(TransactionScopeOption.Required, transactionOptions))
{
try
{
objUploadReceive.updateDispatchHDRData();
objUploadReceive.updateDispatchDTLData();
DispTran.Complete();
lblMessage.Text = "Dispatch Data Upload Successfully.";
DispTran.Dispose();
}
catch (TransactionException ex)
{
common.writeLog(ex.Message, "Interface Updation Dispatch", "Exception");
MessageBox.Show("Transaction Exception Occured");
}
}
when I clicked on the button to perform task. It will upload data . at the same time when i checked data in oracle it is showing. But when i clicked second or third time on the button . It shows last data. Means it is unable to show live data . after closing the application the i am able to get data in oracle...
I need a suggestion where is the mistake.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
0
)
Next Recommended Forum
TextBox control adding in a user control
submit data in database (MsSQL )