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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


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

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

By default the complete memory dump option is disabled in windows . If we want to enable the complete memory dump for a diagnostic purpose, we have a solution for it. here we are using the registry method to enable this.
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
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 basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

627 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