Click here to Skip to main content
15,846,038 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi everyone,

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 :)

[Edit]Shouting removed[/Edit]
Updated 6-Feb-13 6:30am
MrteR 6-Feb-13 21:05pm    
i have set the doublebuffering to true.
that resolve the flickering and make my datagridview faster.
i forgot that setting.
i hope that somebody could help me out with the rest of my question.

1 solution

after every change i do a SELECT * FROM .., it seems there's no other way
thanks to everyone who took the time to read my question
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900