Re: How to avoid users pick same case


<joyo2003us@xxxxxxxxx> schreef in bericht news:643253b1-8ef2-4a6e-8028-9646d04b9ef9@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I have a form which was split into two parts. One datagrid is on left
side which lists pending case numbers. The right side have textboxes
to display the detail information of each case. The case information
will be displayed when the row of case number is double clicked. The
user will give the further process for the case, then the case goes to
next step. The case number will be removed from the datagrid. What I
am doing now, I am using a timer to check the database every 6
seconds. I am using ADO and Access database which is located on the
shared drive. It is still possible that two users could pick one same
case at same time. How do I avoid this conflict? Will it bring very
heavy network traffic if I change the time to refresh every second or
even less or you could give me a different solution? I have about 10
users who will connect with database all the time.

Thanks

joyo

My two cents...
In a 'general' table I have a field named InUse (Boolean).
When the first user doubleclicks for editing I check if
inUse = 1. If so, I display a message and skip.
If not, I write a 1 in InUse and let the user do his job.
After finishing I write again a 0 in InUse.
I use this method for real critical situations like
sending payments to the bank.

This method of course 'locks' the entire editing of all cases.
But if your cases are a limited number (10?) you could
think of 10 fields in that general table.
Bert.


.

Relevant Pages

  • Re: How to refresh a datatable??
    ... then you don't need to requery the database ... > But I want to display the table IncomeProducts in the DataGrid like that: ... > And now I display this View on the DataGrid ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to refresh a datatable??
    ... Hello Bill! ... display all the updated data in the DataGrid (DataGrid is used to display ... > that your update is successful, the database and the local datatable ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: best way to tackle issue with writing Data, Appending Data and Rea
    ... data that I have read from my database and the two are related. ... would help me in my display of data in a grid. ... Read user input and store user input and DataRow to a file. ... display user input and data row in a DataGrid. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Drop Down List for SQL Database
    ... list using the BindingContext. ... //Get the data from the database ... > This is the code im using to display in datagrid: ... > Can someone Please shwo me how to display this column in a DropDownList??? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: User input directly into datagrid or table?
    ... My database table will not be in the ... same format as the datagrid that I wish to display to the user. ...
    (microsoft.public.dotnet.framework.aspnet)
Loading