Problems with running C# program on seveal computers on a network.

Posted on 2013-12-20
Last Modified: 2013-12-21
Hey guys!!!

I have an app that is running on several computers.  In this app I have a timer that retrieves information from the web and saves it to a table which updates the dgv.  My question is when one employee selects a row in the grid how to locked it on all the other computers as well as all the other rows with the same ID.

Question by:JDL129
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 12

Accepted Solution

ktaczala earned 250 total points
ID: 39733764
Don't think you can lock it but, you could use stored procedure to check if record has been updated by someone else, then refresh record.
LVL 22

Assisted Solution

p_davis earned 250 total points
ID: 39733807
you would have to modify for your specific scenario/setup but you could get index/primary key for the row and set that as a static variable/object to enable/disable row editing as needed.
LVL 22

Expert Comment

ID: 39733808
and then, maybe give a message/error that the row isn't editable
SendBlaster Pro 4 - Bulk Email Sending Software

SendBlaster 4 Pro - Best Bulk Emailing Sending Software
Automatic Subscribe / Unsubscribe Processing
Great for Newsletters & Mass Mailings
Optional HTML & Text Composition
Integration with Google Features
Built in Spam Score Checking
Free Professional Templates - Feature Packed!


Author Closing Comment

ID: 39733816
Great ideas!!  I wasn't thinking along those lines.
LVL 22

Expert Comment

ID: 39733820
well, thank you. glad to have helped.

Author Comment

ID: 39733873
I was thinking about adding a field to the table and populating it with the computer name when it is selected.  When the timer refreshes the dgv it would only select the rows with the current computer name or blanks in the new field.  That way none of the other computers would have access to the rows.

Thanks again, you guys are wonderful!!!


Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
Suggested Courses

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question