I have a question about multiuser applications and refreshing the datasource of datagridview etc.
When an user creates a new record in a datatable (or modifies, delete one) i think the best way is to get all the tabledata (of the database) after the update to the database.
Then you can be sure that u have the current data in your local datatable.
Every change (insert,update,delete) is immediately updated into the database.
Now after every change i do a simple "SELECT * FROM .." to get everything.
The data gridview flicker, which I find not very tidy
My question is therefore: is this the right way or is this wrong?
I've googled for hours, but I can not get out.
Is there anyone who can help me with this, that would be very very appreciated.
sorry for my bad English, I'm a Dutchman