Help... first SQL Mobile project

[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.

 

[Peter Morris [Droopy eyes software]]

There are lots of articles about this on the web.

 

[Arun]

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

 

[chook.harel]

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

 

[Arun]

Have a look at this thread,
http://groups.google.co.in/group/mi...df29d?q=arun+printing&rnum=1#b47c6261fc8df29d

Better use word "printing" and do a google group search
http://groups.google.com/advanced_group_search
you will get lots of threads discussed the same topic and few will
really help you to start with.

Hope this helps,
Cheers,
Arun.
www.innasite.com

 

[chook.harel]

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 !