TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Ravi Shekhar
362
4.5k
2.1m
Need help in Transactionscope
Dec 12 2013 4:19 AM
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.
Reply
Answers (
0
)
Can I Create IOS Application Without Mac book.
Crate installer for WIX and should be deployed in IIS.