Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
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 Smile | :)
 
[Edit]Shouting removed[/Edit]
Posted 6-Feb-13 6:27am
MrteR448
Edited 6-Feb-13 6:30am
ProgramFOX142.5K
v2
Comments
MrteR at 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
0 Sergey Alexandrovich Kryukov 429
1 OriginalGriff 419
2 Maciej Los 310
3 CPallini 180
4 Peter Leow 160
0 Sergey Alexandrovich Kryukov 6,933
1 OriginalGriff 5,417
2 Peter Leow 3,997
3 Mika Wendelius 2,850
4 CHill60 2,748


Advertise | Privacy | Mobile
Web04 | 2.8.150224.1 | Last Updated 4 Mar 2013
Copyright © CodeProject, 1999-2015
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