Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# SQL .NET MySQL
Hello friend,
 
I am Working in Windows Application which is for multi user. There is grid view in Form.
My problem is that If a User change value in the combobox-Cell of Grid View on that time Other user can not able to change value, Until the Grid View Update.
I used flag in database but its not working properly. Please suggest me what should I use?
I am using MYSQL as a database
 
Thanks in Advance
Neetesh Agarwal
Posted 5-Apr-13 23:19pm
Edited 6-Apr-13 1:11am
v4
Comments
onurag19 at 6-Apr-13 4:43am
   
Is Same form is opened at same time.
Neetesh Agarwal at 6-Apr-13 4:49am
   
Yes in Different System.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Set a flag in database say Status column.If the column value is 1 then it is open some where.In this case restrict the user to access the database.
 
In the other case if 1st user is accessing the database means the status field will be 1.And once the user updates the database then only make the status column as 0.Then only other user can access the database.
 

I told the logic.Try it your own.If you will have any confusion then let me know.Ok
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 8,284
1 Sergey Alexandrovich Kryukov 7,327
2 DamithSL 5,614
3 Manas Bhardwaj 4,986
4 Maciej Los 4,920


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 8 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100