Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#4.0
Pls help me in Following issues:provide me code for Apllication can be worked in offline mode.till connect online.save its data to server when its connect online to server.I am using visual basic 10.0 windows form application and mysql database
can work online and auto-save its database and all actions on server.
 
can work offline and save its database on pc .. till it connect online ..auto-save work then to save database and all actions on server.
Posted 1-Feb-13 2:02am
Comments
owencampbell at 1-Feb-13 7:10am
   
Hi,
 
What code do you have at the moment? I'd rather suggest fixes to your current code then write a random app for you.
pankajgarg1986 at 1-Feb-13 7:11am
   
currently i have no code.can you pls suggest me the write code for doing that task

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

As you will probably want to see the data you entered during online session also when you are offline, I suggest the following approach:
1) determine what subset of the remote database you could need when offline
2) add a local database to your application; an embedded one for example, it can be also an other implementation than mysql (google for them, there are many)
3) make your application to work directly in the local database
4) make a distributed transaction based synchronization task/service that will do sync often when online and has the logic to reestablish connection as possible
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 277
1 Maciej Los 210
2 BillWoodruff 205
3 Jochen Arndt 180
4 Sergey Alexandrovich Kryukov 165
0 OriginalGriff 5,130
1 DamithSL 4,157
2 Maciej Los 3,650
3 Kornfeld Eliyahu Peter 3,460
4 Sergey Alexandrovich Kryukov 2,811


Advertise | Privacy | Mobile
Web03 | 2.8.141216.1 | Last Updated 1 Feb 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