I have written a few apps in Visual Studio 2008 for the WorkAbout Pro and have always used text files as data and just loaded them in as a datatable. And the scanners never had wifi so we used async to transfer data back and forth. I am now about to write an app for a unit with wifi and I plan to look into using the Compact Database on it wich I have never used before.
With wifi, how is it best to move data on and off the unit? I know if I want to pass data to something like MSSQL I could probably connect to the server and call a stored procedure to update or insert? Is this possible? Just looking for the best ways to move multiple records and that is automated so they don't have to mess with async and can be done programically. I assume to load in data I could call a Select stored procedure and read in the data that way? Is this the best way?
Thanks for your help!
Yes, you can use sqlce. Have a look at the below posts to see some of your options.