Hey there friends,

I am starting to learn .net (worked in Java / MainFrame systems until
now), and I have a project that I need to finish ASAP

The project is on PPC2003SE, and the forms and all I can manage (I'm
using VS2005 as the developing environment)

I'm having trouble with the sql mobile implementation...

I need the PDA to work stand-alone, offline, so I need the DB to sit on
it alone, not needing any outsourcing.

Can you plz advise me on how to do it

Basically until now I came up with these following lines:

using System.Data.SqlServerCe;
...

string connString = "Data Source='Test2.sdf'; LCID=1033; Password=111;
Encrypt = FALSE;";

SqlCeEngine engine = new SqlCeEngine(connString);

If you can just explain in a few sentences how the whole
engine/connection/query thing works here (and of course on the
resultset) I'll be more then pleased.

(I am familiar with JDBC / ADO(not .net) so this shouldn't be to much
of trouble to explain to me)
Hope for a quick reply from you guys

Chen.