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 5:27am
MrteR419
Edited 6-Feb-13 5:30am
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 480
1 mhegazy94 460
2 Ravi Bhavnani 190
3 Kornfeld Eliyahu Peter 185
4 Shemeemsha RA 160
0 Sergey Alexandrovich Kryukov 7,205
1 OriginalGriff 6,801
2 CPallini 5,350
3 George Jonsson 3,644
4 Gihan Liyanage 2,797


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