Click here to Skip to main content
15,887,485 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

There is a requirement to develop a web application using .net driven with SQL Server database which should also work in an offline environment.

Moreover, If user makes a transaction in the connected mode with the web, it works well. But if user also wants the same in offline mode i.e. without internet connection, it should be working fine as well. After that when it resumes internet service, it is supposed to sync all the transactions with the database server.

Please suggest the best way to perform the same.
Posted
Comments
Richard MacCutchan 7-Oct-13 6:36am    
How would the user enter transactions in offline mode?

If you are planning to use a WPF/Winforms client app (which connects to the server over the internet), then this shouldn't be too difficult, the offline data would be stored in a localdb and when you go back online, you would just "sync" with the server, you would need to think about record locking, but it would be very straightforward to do depending on what the data is.
 
Share this answer
 
Comments
Ashish Naval 8-Oct-13 2:25am    
Hi, Thanks for your suggestion but I need an application that can be accessed from browser from anywhere anytime but the operations could be performed in the non availability of network.
Richard MacCutchan 8-Oct-13 4:49am    
There is no easy way to do this because the browser has nothing to connect to if the server is offline, so it cannot load any pages that would contain the transaction handling code.
If you can give me more details of what type of data is going to be moved offline and the type of app you need, I might be able to come up with a better answer. But all I can think of at the moment is some sort of local javascript app.
 
Share this answer
 
Comments
Ashish Naval 9-Oct-13 8:25am    
Hi, Actually there is a requirement for an inventory mgmt. system that is supposed to work offline as well as online on browser which facilitates daily transactions of purchase, dispatch etc. Moreover, if it should work in network unavailability also.
You can use HTML5's Application cache feature to make the web application work offline. For more details refer this link [^]
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900