PocketPC Toolkit.com
PocketPC Toolkit.com


SQLCE Database Viewer - Features
Page 1 2 3 4 5

SQLCE databases.
Together with .Net CF, they make writing apps for Pocket PC (Windows Mobile) devices incredibly easy. The one thing that's missing is a way to view & edit your SQLCE tables, and add sample data to them, without having to tap away manically at your device's screen.

Well folks, I think it's about time to fill that gap.


Imagine ActiveSync's "Explorer" window, crossed with a Desktop version of Query Analyzer, throw in compatibility with SQLCE 2.0 and SQL Server Mobile 2005 (Visual Studio 2005) .sdf files, and you've got a pretty good idea of what to expect.

Features:

  • view a list of tables in your .sdf file.
  • view and edit the data in any of your tables.
  • run SQL commands on the data, and see the results in real-time.
  • add, delete and "clone" rows of data
  • view a list of all of the SQLCE databases (.sdf files) on your device.
  • Compact (and sometimes repair) your SQLCE databases, simply by right-clicking on an .sdf file and selecting "Compact".
  • intelligent SQLCE library support, it will work out if an SQLCE database is SQLCE 2.0 compatible, or an SQL Server Mobile Edition database.
  • export your .sdf tables (with or without their data) to an Access database or ODBC data source.

If you're already using SQLCE databases, then the coolest thing about this app is that simply looking at the screenshot above, you can already see exactly what the application does, and will instantly know if you want it.

And, even better, you already know how to use it.. it's like every PC-based database you've ever used. Click once on an item of data to highlight that row, click twice to start editing an item of data in it. Hit ENTER to save it back to the device.

It really doesn't get much easier than this !

Next page    Home