Updating with multiple users
Posted on 2009-02-17
This is a bit of a general question but here we go.
I have a datagridview on a windows form (VS 2005). This DGV gets its data from a dataview which feeds off a dataset which gets its data from a SQLdataadaptor (Looking at a SQL Server 2000 database). The DGV is filled on open and any changes (deleted/inserted or changed records) are saved on exit.
My query is. What happens if three users have the form open. One adds a record, one deletes a record and one makes a change to a record. What can I expect to be the result? Will it crash or will all changes be written successfully? I'm trying to get my head around the fact different users may be looking at different data depending upon when they opened the form. Someone who leaves it open all day would not see any changes users have been making throughout the day.
How would the experts recommend dealing with such situations?
Thanks in advance
What I would like to know