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

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.

Thanks,
Jerry
JDL129Asked:
Who is Participating?
 
ktaczalaCommented:
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.
0
 
p_davisCommented:
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.
0
 
p_davisCommented:
and then, maybe give a message/error that the row isn't editable
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
JDL129Author Commented:
Great ideas!!  I wasn't thinking along those lines.
0
 
p_davisCommented:
well, thank you. glad to have helped.
0
 
JDL129Author Commented:
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!!!

Jerry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.