How to refresh disconnected database in vb

Question

0.00/5 (No votes)

See more:

I have created a windows application which have server and client version.
SQL database installs on the Server version and client access it.

At the time of opening the application from client it creates a dataset aqnd access it; at the same time if that application is also opened from any other client pc it also create another dataset for that particulat pc. Any changes are not visible on the client pc runtime.

How do i refresh this disconnected databse?

Thanks in advance.

Posted 29-Dec-11 18:47pm

sahabiswarup

Add a Solution

3 solutions

Solution 2

You have used dataset and it's worikng in Disconnected mode.
As word suggest its a "Disconnected Architecture." databse connection get closed after data fetched. so you can't get updated data each time.
so if you want updated data then you need to hit database again.
or use classes that support "connected architectures", like Datareader.

Posted 29-Dec-11 22:10pm

koolprasad2003

Updated 29-Dec-11 22:12pm

v2

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)

JP.SIAVRAJ · Accepted Answer · 2011-12-29T21:50:00

Solution 1

Dear Sir,

I have already face this same problem.
i created xml file and transfer the values between 2 datatable (client - server)

C#

DataTable dt1 = new DataTable("Table1"); 
DataTable dt2 = new DataTable("Table2");
dt1.Merge(dt2);
dt1.WriteXml(@"C:\test.xml");

Regards
JP.SIVARAJ

Posted 29-Dec-11 21:50pm

JP.SIAVRAJ

Updated 30-Dec-11 11:02am

v2

Comments

sahabiswarup 2-Jan-12 7:48am

thanks for your valuable comments i'll try your way.

Ahmed_online · Accepted Answer · 2011-12-30T00:30:00

Solution 4

you can make a Sub to clear DataSet and Fill it again , write this sub in a button event or a timer