Simple localized database question

[AG]

Hey all,

I'm normally involved with ASP.NET development but I've been tasked
with creating a windows form application that stores it's database
locally (because many users will not be connected to the internet) but
is capable of connecting online and updating it's local database when
an internet connection is available.

In short: how do I do this? I've never had to create a windows form
before, let alone an integrated database. Anyone have any links/
suggestions/pointers/book recommendations?

Thanks much!

-AG

 

[Alberto Poblacion]

I'm normally involved with ASP.NET development but I've been tasked
with creating a windows form application that stores it's database
locally (because many users will not be connected to the internet) but
is capable of connecting online and updating it's local database when
an internet connection is available.

In short: how do I do this? I've never had to create a windows form
before, let alone an integrated database. Anyone have any links/
suggestions/pointers/book recommendations?

If you are using Visual Studio 2008, you can use Synchronizaton Services.
You simply Add a new Item to your project form the template called "Local
Database Cache". This starts a wizard that creates a local database in your
project using the Sql Server Compact dlls and adds the synchronization code
into your project so that you can easily update the local copy when a
connection to the server is available.

 

[Alberto Poblacion]

I'm normally involved with ASP.NET development but I've been tasked
with creating a windows form application that stores it's database
locally (because many users will not be connected to the internet) but
is capable of connecting online and updating it's local database when
an internet connection is available.

In short: how do I do this? I've never had to create a windows form
before, let alone an integrated database. Anyone have any links/
suggestions/pointers/book recommendations?

If you are using Visual Studio 2008, you can use Synchronizaton Services.
You simply Add a new Item to your project form the template called "Local
Database Cache". This starts a wizard that creates a local database in your
project using the Sql Server Compact dlls and adds the synchronization code
into your project so that you can easily update the local copy when a
connection to the server is available.