From: RideSearch on
Hello all,
I am testing a website that uses SQL Server 2005 membership
provider. I would like to have a pocketpc WM5 or WM6 application that
can register users disconnected and then when I sync update the SQL
Server. Here are what I think my programming options so far:

1. Create a .Net Compact Framework App that uses the aspnet_user
tables in a local SQL Server Mobile edition. Then figure out how to
sync that with the main DB.

2. Create a .Net Compact Framework App that creates XML files for each
user. Then when I sync take these files and use SSIS to take the XML
file and send it to the Database

3. Create a .Net Compact Framework App that uses the WebBrowser
Control and has a cache and then calls a webservice when it is online
to create the users

4. Create a .Net Compact Framework App that creates a sql script for
each inputed user then execute it on the main db when I sync later.

Has anyone seen or used this type of app? Can anyone see or think of
the quickest solution?

Thanks
Brian B
From: dbgrick on
The Windows Mobile Accelerator 2008 pack has an example that does what you
are requesting. Here is the link:

http://www.microsoft.com/downloads/details.aspx?FamilyId=428E4C3D-64AD-4A3D-85D2-E711ABC87F04&displaylang=en

Regards,
Rick D.


"RideSearch" wrote:

> Hello all,
> I am testing a website that uses SQL Server 2005 membership
> provider. I would like to have a pocketpc WM5 or WM6 application that
> can register users disconnected and then when I sync update the SQL
> Server. Here are what I think my programming options so far:
>
> 1. Create a .Net Compact Framework App that uses the aspnet_user
> tables in a local SQL Server Mobile edition. Then figure out how to
> sync that with the main DB.
>
> 2. Create a .Net Compact Framework App that creates XML files for each
> user. Then when I sync take these files and use SSIS to take the XML
> file and send it to the Database
>
> 3. Create a .Net Compact Framework App that uses the WebBrowser
> Control and has a cache and then calls a webservice when it is online
> to create the users
>
> 4. Create a .Net Compact Framework App that creates a sql script for
> each inputed user then execute it on the main db when I sync later.
>
> Has anyone seen or used this type of app? Can anyone see or think of
> the quickest solution?
>
> Thanks
> Brian B
>