DATASET UPDATE OR REFRESH

Question

3.40/5 (2 votes)

See more:

.NET2.0

Hi,
I'm writing a multiple user C# Windows Application,
my problem comes in if someone else changes/adds a record on their app on their machine,
it is not showing on the other machine unless the tableadapter.fill is called.
If i fill the table adapter on a timer, my listbox is flickering.
Any ideas how i can refresh my data in my dataset without causing delays on the app. Tried backgroundworker aswell with no success.
Somehow i need to see if the dataset is the same as the DB, if not it should update. and with no delays on the application. I am using a Firebird Database.
Thanks

Posted 25-Jul-11 14:30pm

jpveldtman

Add a Solution

2 solutions

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)

uspatel · Answer 1 · 2011-07-25T19:05:00

Solution 1

To refresh dataset You can Reset dataSet and fill it again.

C#

this.YourDataSet.Reset();
this.YourTableAdapter.Fill(this.YourDataSet.table);

Posted 25-Jul-11 19:05pm

uspatel

Comments

jpveldtman 26-Jul-11 2:38am

Thanks for the reply, I did try the fill, but this causes my program not to respond for about 3seconds, and then the Listbox that is populated by the dataset flickers.

Richard Fernandes, Dubai, UAE · Answer 2 · 2014-01-18T18:01:00

This code is without using tableadapter, but with dataadapter.Please clear your dataset with Clear() function and then Fill() the dataset.I have used MS Access Database with OleDB Connection

string con1 = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Documents and Settings\sam\my documents\visual studio 2010\Projects\WindowsFormsApplication1\WindowsFormsApplication1\Database1.accdb";
           string query1 = "SELECT * FROM Table2";
           OleDbDataAdapter da1 = new OleDbDataAdapter(query1, con1);
           OleDbCommandBuilder cmd = new OleDbCommandBuilder(da1);
           da1.Update(database1DataSet2.Table2);
           this.database1DataSet2.Table2.Clear(); //clears the dataset
           da1.Fill(database1DataSet2.Table2);