Hello,

      Is real time updation on a offline database possible?

   eg:- A user logins to my site and purchases a product, before he enters his personal details and credit card number my database went offline for a maintenance. Can I update the data entered by the user into my database even if the database is offline.


Please help me.

regards:),
John

why not!!!
provide us with more information...
when you change your dataset(in offline mode) you can update your datasource through a CommandBuilder(SqlCommandBuilder,OleDbCommandBuild er)..it causes to update your datasource..then you can again retrieve your new datasource.

--------------------------------------------
Mehdi.:)

Depends how your doing things.

If you have the data in an offline dataset, and the SQL server bounces.. you can always fluysh the dataset out when the sql server comes back- but you have to keep that dataset active and checking.. it would be a nice bit of code to do...

Why do you expect your SQL Server to go offline?


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

I am facing the real problem but the Idea that I want the user to run the application offline and works with the data offline and when he finished updating the offline data from the datagrid control he just click on the update button then the application connect to the sql server and update or synchronize the data .