VB.NET multiuser application refresh datasource after INSERT, UPDATE to database

Question

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]

Posted 6-Feb-13 5:27am

MrteR

Updated 6-Feb-13 5:30am

Thomas Daniels

v2

Add a Solution

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

MrteR · Accepted Answer · 2013-03-04T11:31:00

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

Posted 4-Mar-13 11:31am

MrteR