Help... first SQL Mobile project

  • Thread starter Thread starter chook.harel
  • Start date Start date
C

chook.harel

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.
 
MSDN is the best book for this,
You can download SQL Mobile books online in this link,
http://download.microsoft.com/downl...74-bd15-57a8c4c34444/SQLMobileBooksOnline.exe

There is an web cast explaining SQL Mobile,
http://msevents.microsoft.com/cui/W...&EventCategory=5&culture=en-US&CountryCode=US

Darren Shaffer's Blog
http://dotnetjunkies.com/WebLog/darrenshaffer/default.aspx

As Peter mentioned, there are tons of articles in web, you can even do
a google group search to find out more on SQL Mobile,

Cheers,
Arun.
www.innasite.com
 
Thanks alot for the info!
I will sure look at the links you've put down..

My main concern up till now is the reports I need to print from the
Mobile
(A topic above this one)
If you could help me there, It would be a great thing :)
 
Thanks again,
but as I see it every solution costs money,
The solution from FieldSoftware Products
talks about ordering from 100 licences and above..
I only need one ! :(
 
Back
Top