Click here to Skip to main content
13,052,558 members (57,479 online)
Rate this:
 
Please Sign up or sign in to vote.
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]
Posted 6-Feb-13 5:27am
MrteR657
Updated 6-Feb-13 5:30am
ProgramFOX198.5K
v2
Comments
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

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

Solution 1

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
  Permalink  

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 4 Mar 2013
Copyright © CodeProject, 1999-2017
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