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
dc
NA
663
0
C# update sql server 2008 table
Sep 30 2012 8:17 PM
I have a question about a C# 2008 application that calls C# 2008 application by using 'Process exec_calc = new Process();'. Curretnly the first C# 2008 application creates output excel spreadsheets that are emailed out to customers.
Now the first C# application will count the number of rows that are generated on the excel spreadsheet. The first program will insert a new row into a customer table that is setup by customer number and count in a sql server 2008 r2 database. Now the first program will call the second C# application and pass that program the customer number.
When the second C# program runs, it will obtain the customer number from the arguements that where passsed to it. Now the second C# program will read the Customer table to obtain the row that was inserted into the customer table by the first C# program.
This process will continue until all of the customer records have been processed.
The second program will now call a web service with this information. This design needs to stay since 95% of the entire new design has been tested and works. This design will stay since it will make the code production ready within a few weeks.
My question is updating and accessing the customer table. Will I have any deadlock issues? Do I need to consider permission problem(s) and/or access problems that I need to consider? If so, what are the problems and what do I need to do to solve the problem(s)?
Reply
Answers (
0
)
Constructor and get and set method
windows appliction resize application based on screen resolution dynamically