locked
What is the best way to download data from a SQL database to a Mobile 6.1 device RRS feed

  • Question

  • Hello,

    I need to make an application on a Mobile 6.1 device. The one thing I have no idea how to do is how to get data from a SQL 2008 database to the Mobile 6.1 device so I can use the data in the application on the device. And while I am asking; after I manipulate the data on the device how to I get the data back into the SQL 2008 database?

    Thank You

    Wednesday, July 20, 2011 10:35 PM

Answers

All replies

  • The easiest way I can think of to do what you want is to write the application for the desktop using the RAPI2 interface. It includes APIs for interfacing with databases on the Windows Mobile device and extracting data. Once you have the data, you can use the usual Microsoft OLEDB API to interact with the local database on the PC.

    RAPI2 API: http://msdn.microsoft.com/en-us/library/aa920150.aspx

    OLEDB API: http://msdn.microsoft.com/en-us/library/ms722784%28v=vs.85%29.aspx

     

    -PaulH

    Thursday, July 21, 2011 5:35 PM
  • Thank you this sounds like what I need. Any examples of apps using RAPI2 that you can point me to?

    Thanks

    Thursday, July 21, 2011 5:48 PM
  • Yes, here is a codeproject article with general RAPI2 usage.

    http://www.codeproject.com/KB/windows/CeDir.aspx

    -PaulH

    • Proposed as answer by Jesse Jiang Monday, July 25, 2011 6:54 AM
    • Marked as answer by Jesse Jiang Friday, July 29, 2011 6:54 AM
    Thursday, July 21, 2011 7:37 PM