Data Replication from Windows Form to SQL Server

[robin9876]

In VS.Net 2005 Is it possible to replicate data between a windows form
and a SQL 2005 database?

 

[RobinS]

Depends on what you mean by that. You can read it from the database
and put it in the form; you can read it from the form and put it into
the database. A little databinding in the middle makes it happen
automatically.

Robin S.

 

[robin9876]

How would you securely store the information on the client in between
connecting to the main database?

 

[RobinS]

Some kind of binary serialization probably. Depends on how secure it
needs to be.

Robin S.
-------------------------

 

[robin9876]

What process is used to create a binary serialisation file?

 

[RobinS]

Actually, Binary Serialization isn't good enough; you can still see some of
the data. You need to check out the Encryption classes in .Net. Check out
MSDN and search for Encryption or cryptography.

Robin S.
---------------------------